How to get DATE format as (05/10/2023 04:54:27)

[TTH1]

Hi All,

In replicate if i do DATETIME('NOW')  the format is changed..I need this format DD-MM-YYYY HH:MM:SS 

Could you please advice.

Thank you,

[Arun_Arasu · Accepted solution]

Hello @TTH1 ,

Thanks for reaching Qlik community,

Can you please try the below function and let us know if that helps with your request

strftime('%d-%m-%Y %H:%M:%S', 'now', 'localtime')

OR

strftime('%d-%m-%Y %H:%M:%S', 'now')

Thanks & Regards

Arun