Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to set NVL date field on workflow action formula
Hi all
I have 3 date fields and want to find the one with the earliest date.
Sometimes some of the fields are empty so I need to use the NVL tag.
When I use the below formula it always returns 01/01/2099 even when the dates are for example 23/11/2022.
Does anyone know why this is?
Code below, thank you.
Least(NVL(to_char({custitem_rlrs},'dd/mm/yyyy'),'01/01/2099'),NVL(to_char({custitem_blrs},'dd/mm/yyyy'),'01/01/2099'),NVL(to_char({custitem_tlrs},'dd/mm/yyyy'),'01/01/2099'))
kind regards
Oliver