657 76 Home » Wapka Codes 2021 » Setting a different time zone for the DATE function fchagas97 fchagas97 1 year ago Due to an apparent bug, the DATE function always uses the UTC time zone, even if you have set a different time zone in your Site Settings. To display the date in a different time zone, use the following workaround as an example: :VALUE(+03:00).DATE(); And you will have the time displayed in the UTC-3:00 time zone (I can't explain why you use + to set a negative time zone o_o) If you want the time displayed in UTC+3:00, use the following example: :VALUE(-03:00).DATE(); Note: the function will not take into account whether it is daylight saving time or not in the time zone you chose, because technically the time zone is still UTC.

comment