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.
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.