Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Convert the format in AMPM

Hi All,

I have below field in my data table:-

Current format is MM/dd/yyyy hh

Aspiring_Developer_0-1606969548089.png

I wish to show the AM PM also for the above column.

Can anyone please help on how can we achieve it ?

Thanks in advance

2 Replies
JoaoRomao
Partner - Contributor
Partner - Contributor

Hi!

Please, try the datetime format like 'MM/dd/yyyy hh tt'

Best regards

Aspiring_Developer
Creator III
Creator III
Author

Hello ,

Thank you for your response. 

In my data , field Tstamp coming from SQL

Aspiring_Developer_0-1607491867070.png

When i reload it and take this field in front end and change the format, it is still not working 

Aspiring_Developer_1-1607492063992.png

Can we directly change the format in SQL (screenshot attached above) into AM PM format and directly fetch in qlik ?

Can you please help me ?