How to convert Singapore time based field values to UK based time values?

[jblomqvist]

Hello all,

I have a DateTime field which records data in Singapore time.

When analysing the data in the UK it makes little sense to the users so how can I show the same timestamp data but on UK time?

So basically I want conver the following values in UK time:

2019-04-01 03:30:20

2019-04-01 03:35:34

etc

[dplr-rn]

try
ConvertToLocalTime('2019-04-01 03:30:20','Singapore')

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

[Vegar]

I guess you could use ConvertToLocalTime() https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

[jblomqvist]

Hi guys,

This almost works.

It appears to show one hour ahead?

For example here in the UK it is 8pm currently, when I use your expression, it's showing as 04:00am Singapore time, but it is actually 3am over there currently.

The clocks just went forward so it's not taking this into account?

[dplr-rn]

play around with ignore_dst argument
look at the link for details on arguments
not sure if true/false is the right one. (always confused by Daylight savings :-))

[jblomqvist]

Hi Dilipranjith,

Sadly that seems to make no difference when I enter true or false as arguments!

[dplr-rn]

ok. looking more into it the function it may not be what you want as that function converts UTC time to a local (specified in argument) and i believe you want it the other way round. i.e. singapore to uk.

i am not sure now 😞