Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I don;t think this script is working properly. any ideas why it is returning pm instead of AM?
ConvertToLocalTime(Timestamp(Now()),'GMT+02:00')
Right now I know it is AM in Paris for example.
Thanks
Try like this
=localtime ('GMT+02:00')
Perhaps you need to chance it as local first and then convert into needed like below
ConvertToLocalTime(UTC(Timestamp(Now())),'GMT+02:00')
Hi Devarasu,
I am trying to convert from my local time to the time to the Time in Paris.
example:
Local time : 2017-10-20 8:05:06 PM
I want to convert that to the time in Paris.
Thanks
From hello one example is there related paris. Have you tried that
help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/converttolocaltime.htm
Hi Anil ,
Can you please brief this
"ConvertToLocalTime(UTC(Timestamp(Now())),'GMT+02:00')"
What UTC stands for and how it is work ....
Sorry Anil,
When I replaced the Timestamp(Now()) with my timestamp field name it still returns the same value.
ConvertToLocalTime(<mytimestampfield>,'GMT+02:00') return the time in paris now although my fied value is 2017-10-20 8:05:06 PM
What UTC stands for and how it is work ....
https://www.google.co.za/search?q=UTC
That means, first you need to convert your now() function to local then convert into needed