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?
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.
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.
Thanks,
Girish S.
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")
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156