Support Article
Daylight Savings does not happen on using FormatDateTime
SA-41650
Summary
Daylight Savings is not performed during EST to GMT date time conversion in the FormatDateTime function.
Error Messages
Not Applicable
Steps to Reproduce
Convert the time from EST to GMT using the FormatDateTime function.
Root Cause
Incorrect date was displayed, after EST to GMT conversion, as the Daylight Savings time was not taken into consideration by the FormatDateTime function.
Resolution
Use the AddDate function instead of the FormatDateTime function.
Published September 14, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.