Change time zone ONLY for one field

Question & Answer
, ,
1

Hello,

I have data in the same dataset coming from different timezones. I found the nice features that changes all the data type column according to a specific UTC.

However I wnated to change only 1 of them.

I tried to do like this:
parseDate(toString(formatDate(timestamp,‘MM-dd-yyyy’,‘Europe/Stockholm (UTC+02:00)’)))

image
but it does not work.

Is there a better way to change only one column to a specific timezone?

thank you

2

Sorry I noticed of an error, the new calculated field is
parseDate(toString(formatDate(timestamp,‘MM-dd-yyyy HH:mm:ss’,‘Europe/Stockholm’)),‘MM-dd-yyyy HH:mm:ss’ )

but it does not add the 2 hours to the timestamp column

3

Hi Luca @remba87,

If you want to add an offset to just one date field, you can do it using addDateTime function.
Sample given below.

addDateTime(2, 'HH', {Order Date})

Regards,
Arun Santhosh
Pr QuickSight SA

1 Like
4

@ArunSanthosh Hello, yes, I tried this, however, this will not take into account the fact that during winter, instead of 2 I should put 1 since the time will change…