Date/Time stamp looks wrong

Just ran a test on a workflow that uses the Date-times: Get current date & time action followed by Dates: Format a Date Time action. The run shows that the field for current time (1st action) was 11/3/2020 3:25 PM, not in UTZ as I would have expected (e.g. YYYY-MM-DDTHH:MM:SS.sssZ). Next, the format action was applied using the format YYYY/MM/DD hh:mm:ss with an offset of -6. This resulted in the field showing 2020/11/03 02:25:00, which is 13 hours earlier than the unformatted date/time. When I uploaded that to my data table, it became 11/03/2020 2:25 AM (the field in the table is set as Date and Time).

Am I doing something wrong here?

Sign In or Register to comment.