I'm trying to set an expiration date field. If da...
# generala
Amber Thompson
10/22/2020, 3:17 PMI'm trying to set an expiration date field. If date is before December 01 of current year, set expiration date to December 31 current year. If date is after December 01 of current year, set expiration date to December 31 of next year.
s
Sandii
10/22/2020, 3:21 PMHow are you trying to set it (workflow, script, etc) and what is the context of when it gets set.
a
Amber Thompson
10/22/2020, 3:22 PMWorkflow after field edit
s
Sandii
10/22/2020, 3:25 PMYou should be able to get it to work with a CASE WHEN formula
https://www.abaci-us.com/netsuite-to-date-to-char-date-functions/
Sandii
10/22/2020, 3:25 PMThere is a page about how to extract pieces of date information from the field values
a
Amber Thompson
10/22/2020, 3:25 PMThanks so much, I'll check it out!