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.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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