Show date fields in the user local time format

[mikiap]

Hi all

I have a report that extracts the reported_date field from a database, where the date is stored in GMT time.

Currently in the report this reported_date is shown in GMT time (like in the database).
I would like to know if there is a function in Report Studio that converts this date into your local time and displays it as such in the report. Or maybe some settings in the user preferences.

for example:
database field: reported_date= 31.03.09 06:30:00
a user in switzerland should see in the report: reported_date= 31.03.09 08:30:00
a user in UK should see in the report: reported_date= 31.03.09 07:30:00

I'd be grateful for an answer!
regards
Anca