Displaying time in the proper time zone

Hi,

If you converted the date field to a text - for example through a formula field, it always converts to UTC. The solution is use the datetime_format_tz() when using dates in formulas and set the appropriate time zone.