DATE FORMATES

[shravanveer]

hi 

I have different date format in single field ,how should covert into single format in QlikView  

date

12-03-2022

13-03-2022

14-aprl-2022

15-aprl-2022

04/18/22

05/19/22

[marcus_sommer]

It could be done with:

alt(date(date#(DateField, 'Format1')), date(date#(DateField, 'Format2')), ...)

By monthnames they must fit to the set interpretation-variables to be resolved which are usually at the beginning of your script but you could overwrite them multiple times within the script if you need a different behaviour.

- Marcus