Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?