topic Re: Qlik Sense Function in App Development

Qlik Sense Function

kabibi15 — Tue, 27 Aug 2019 15:22:25 GMT

Does anybody know the function to convert date in Qlik sense. For example converting '09-18-2000 17:14:07' to '18-Sep-2000 17:14:07'. Thanks.

Re: Qlik Sense Function

Anil_Babu_Samineni — Tue, 27 Aug 2019 15:25:46 GMT

Perhaps this?

=Date(Date#('09-18-2000 17:14:07', 'MM-DD-YYYY hh:mm:ss'), 'DD-MMM-YYYY hh:mm:ss')

Re: Qlik Sense Function

kabibi15 — Tue, 27 Aug 2019 15:35:32 GMT

Thanks a lot that works. But I have a date field 'SET_STATUS_DATE' which i will like to use so that my results should be base on that field.

Re: Qlik Sense Function

Anil_Babu_Samineni — Tue, 27 Aug 2019 15:37:51 GMT

you can use field over the expression like

=Date(Date#(SET_STATUS_DATE, 'MM-DD-YYYY hh:mm:ss'), 'DD-MMM-YYYY hh:mm:ss')

Re: Qlik Sense Function

kabibi15 — Tue, 27 Aug 2019 15:51:18 GMT

Thanks. After using your suggested functions/expression the results is blank/null. any other functions?

Re: Qlik Sense Function

Anil_Babu_Samineni — Tue, 27 Aug 2019 15:55:09 GMT

Where are you trying this? If this is script you can use

This is for all rows are in same format

Date(Date#(SET_STATUS_DATE, 'MM-DD-YYYY hh:mm:ss'), 'DD-MMM-YYYY hh:mm:ss')

This is for all rows in different format

Date(Alt(Date#(SET_STATUS_DATE, 'MM-DD-YYYY hh:mm:ss'), Date#(SET_STATUS_DATE, 'Your Format Here'), Date#(SET_STATUS_DATE, 'Your Format Here'), ....), 'DD-MMM-YYYY hh:mm:ss')

Re: Qlik Sense Function

kabibi15 — Tue, 27 Aug 2019 16:04:07 GMT

I'm trying this at the Expression editor because i don't have access to QMC.