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!
Saved Search results - SQL formula to change a text field to Date/time field
Can someone help me out or let me know if it is even possible in a Saved Search results formula to change a Free form text field into a Date/time format to subtract against a date field (i.e. {today}).
What I'm trying to do is take a custom free form text field that we populate with the date & time just like is seen in system notes (8/17/2010 11:03 am) and compare to the current date/time to get the "days since escalated".
The formula would basically be ({sysdate} - (change field type({'freeformtext field'})) = days since escalated.
I have tried "to_date" command but get an error on the results because I don't think this command is supported in Saved Searches.