topic Re: Reformatting of a datetime filed in App Development

Reformatting of a datetime filed

chinmei — Tue, 30 Aug 2022 02:54:52 GMT

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

Re: Reformatting of a datetime filed

Digvijay_Singh — Tue, 30 Aug 2022 03:28:59 GMT

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')

Re: Reformatting of a datetime filed

chinmei — Tue, 30 Aug 2022 12:14:28 GMT

Hi Digvijay_Singh,

Thank you so much, it works! 🙂