Reformatting of a datetime filed

[chinmei]

Hi, 

I'm rather new to doing logics in Qlik. Hope someone can help here.

I have a date time field which is in the format of yyyy-mm-dd hh.mm.ss.000000 i.e 2020-11-01 16.30.00.000000. I want to re-format it to mm/dd/yyyy hh:mm:ss, how may I do so? I am using this in data filter. 

Any help is deeply appreciated. Thanks.

Rgds,

Chin Mei

[Digvijay_Singh · Accepted solution]

Not sure but may be try this, share sample app if its not working - 

timestamp(timestamp#(DateTimeField,'YYYY-MM-DD hh.mm.ss.ffffff'),'YYYY-MM-DD hh.ss.mm')

[chinmei]

Hi Digvijay_Singh, 

Thank you so much, it works! 🙂