Convertolocaltime returning wrong time of the day

[didierodayo]

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

[devarasu07]

Try like this

=localtime ('GMT+02:00')

[Anil_Babu_Samineni]

Perhaps you need to chance it as local first and then convert into needed like below

ConvertToLocalTime(UTC(Timestamp(Now())),'GMT+02:00')

[didierodayo]

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

[Anil_Babu_Samineni]

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

[prma7799]

Hi Anil ,

Can you please brief this

"ConvertToLocalTime(UTC(Timestamp(Now())),'GMT+02:00')"

What UTC stands for and how it is work ....

[didierodayo]

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

[jonathandienst]

What UTC stands for and how it is work ....

https://www.google.co.za/search?q=UTC

[devarasu07]

Hi,

can you check this

how to convert a local time to utc time when I have the time zone?

Timestamp conversion | Qlik Community

[Anil_Babu_Samineni]

That means, first you need to convert your now() function to local then convert into needed