Hi all - I'm trying to write a (date) formula to set the value based on whether or not another date field has a value. But I'm getting invalid expression. This is the full formula that I tried --

CASE WHEN {custcol_agency_mf_flight_end_date} is NULL THEN {custcol_agency_mf_flight_start_date} + 364 else {custcol_agency_mf_flight_end_date}

I broke it down to this to see if I could get part of it working -- and it's not working either --

CASE WHEN {custcol_agency_mf_flight_end_date} is NULL THEN {custcol_agency_mf_flight_start_date}

any help is appreciated!

Give this a shot: NVL({custcol_agency_mf_flight_end_date}, {custcol_agency_mf_flight_start_date} + 364)

OMG that worked - thank you!!

@Betsy Barefoot Secret Sauce:

Wow! I'm probably one of very few people who hasn't tried Chat GPT - I need to get on that!

That's why I posted it here haha, do not underestimate the things it can help with, has a good amount of accurate NetSuite knowledge as well. Today I just launched a script to automate part of payroll using ChatGPT haha.

that's awesome