FAQ: How do I make a date format take daylight savings into account?

Avatar
Courtney Jordan
Celigo University Level 4: Legendary
Awesome Follow-up
Top Contributor

The date/time field defaults to Standard Time (CST) instead of Daylight Time (CDT) when set to GMT. Use the following steps to change the field to CDT:

  1. Set date format as “YYYY-MM-DDTHH:mm:ss”. For this example, we’ll use: “2020-08-07T05:07:00" 
  2. Set time zone as GMT. This will give you a CST format of “2020-08-06T23:07:00”.
  3. Append an offset of “00:00" to the date: “2020-08-07T05:07:00-00:00”.
  4. Set the time zone as “YYYY-MM-DDTHH:mm:ssZ”. This converts it to CDT.
0

Comments

0 comments

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post