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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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