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.
