topic Convert the format in AMPM in App Development

Convert the format in AMPM

Aspiring_Developer — Thu, 03 Dec 2020 04:29:03 GMT

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 — Thu, 03 Dec 2020 16:22:22 GMT

Hi!

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

Best regards

Aspiring_Developer — Wed, 09 Dec 2020 05:35:39 GMT

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 ?