Notifications
Announcements
No record found.
Hi,
If dateTime is month/day/year with time
Why when we use dateTime2Str it becomes day/month...how can we keep it as month/day?
Hi junior AX,
Please check your user option preferences and language for Date, time, and number format. If it is already setup while date format is not as you expected, you can define format of datetime in your code (e.g. DATEFORMAT(dateTime2Str,"yyyy-MM-ddTHH:mm:ss")
Hi juniorAx,
Hope the below blog from Martin Drab will help you.
As per below blog make use of system.time to convert to specified format.
dev.goshoom.net/.../
Thanks,
Girish S.
It's important to realize that datetime values are not stored as string. If your statement "If dateTime is month/day/year with time" suggest that you think it's stored in a specific string format, you're wrong. A format (such month/day/year) applies only when the urcDateTime value gets converted to a string.
If you don't like the format used by dateTime2Str(), simply use a conversion function that allows you to specify a different format.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
