Convert the format in AMPM

[Aspiring_Developer]

Hi All,

I have below field in my data table:-

Current format is MM/dd/yyyy hh

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

[JoaoRomao]

Hi!

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

Best regards

[Aspiring_Developer]

Hello ,

Thank you for your response. 

In my data , field Tstamp coming from SQL

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

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 ?