Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
MMK
Contributor III
Contributor III

Standard Timestamp to UK timestamp

Hi ,

I am trying to convert a standard timestamp to UK timestamp.

I have taken as - 

 Let vDis_Time=Date((Peek('DIS_DT',-1,'LOG')),'DD/MM/YYYY hh:mm:ss (UTC+00:00)'); on back-end

Also ConvertToLocalTime(vDis_Time, 'London') in front-end text object, but not able to get it.

Expected solution is to be :  03/10/2024 04:56:13 UK

 

Any leads, pls help. TIA

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@MMK  If the format of the field DIS_DT is 'DD/MM/YYYY hh:mm:ss' you could try below

 Let vDis_Time= ConvertToLocalTime(Timestamp#(Peek('DIS_DT',-1,'LOG'),'DD/MM/YYYY hh:mm:ss'),'London');

Provide the format in Timestamp# matching with field value of DIS_DT

View solution in original post

2 Replies
Kushal_Chawda

@MMK  If the format of the field DIS_DT is 'DD/MM/YYYY hh:mm:ss' you could try below

 Let vDis_Time= ConvertToLocalTime(Timestamp#(Peek('DIS_DT',-1,'LOG'),'DD/MM/YYYY hh:mm:ss'),'London');

Provide the format in Timestamp# matching with field value of DIS_DT

MMK
Contributor III
Contributor III
Author

@Kushal_Chawda Thanks alot !! It worked .