Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Workflow - Set Field Value - Convert time/date field to date field
Hi,
I have a workflow where I'm trying to Set a custom Date field with the value from the Date Created field.
If I do the following:
It will pull the date created, but use the current year instead of the year the record was created:
My guess is this is happening because the field I'm trying to set the value to is a DATE field while the Date Created field is a DATE/TIME field. Is there a formula I can use that converts the date created (date/time) field to a date field?
I confirmed the set field value works as expected if it's pulling from another DATE field.
0