No matter what I do, the date and time when using TODAY() is ALWAYS wrong. Even when I try to format it using:
DATETIME_FORMAT(SET_TIMEZONE(TODAY(), ‘America/Chicago’), ‘M/D/YYYY | h:mmA’).
Output:
2020-03-10T19:00:00-05:00
(Format completely incorre...
Just for some more context into the timestamp this is what I’m trying to set up.
So, when “Add1” or “Add2” get selected in the Start field I want the time stamped in the Add_Time, Add_Time2 or Add_Time3 fields depending on what is selected in Start...
