https://community.qlik.com/t5/App-Development/DATE-FORMATES/m-p/1943802#M77769 <P>It could be done with:</P> <P>alt(date(date#(DateField, 'Format1')),&nbsp;date(date#(DateField, 'Format2')), ...)</P> <P>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.</P> <P>- Marcus</P> Wed, 15 Jun 2022 07:20:01 GMT marcus_sommer 2022-06-15T07:20:01Z https://community.qlik.com/t5/App-Development/DATE-FORMATES/m-p/1943779#M77767 <P>hi&nbsp;</P> <P>I have different date format in single field ,how should covert into single format in QlikView&nbsp;&nbsp;</P> <TABLE width="101px"> <TBODY> <TR> <TD width="100px">date</TD> </TR> <TR> <TD width="100px">12-03-2022</TD> </TR> <TR> <TD width="100px">13-03-2022</TD> </TR> <TR> <TD width="100px">14-aprl-2022</TD> </TR> <TR> <TD width="100px">15-aprl-2022</TD> </TR> <TR> <TD width="100px">04/18/22</TD> </TR> <TR> <TD width="100px">05/19/22</TD> </TR> </TBODY> </TABLE> Wed, 15 Jun 2022 06:37:54 GMT https://community.qlik.com/t5/App-Development/DATE-FORMATES/m-p/1943779#M77767 shravanveer 2022-06-15T06:37:54Z https://community.qlik.com/t5/App-Development/DATE-FORMATES/m-p/1943802#M77769 <P>It could be done with:</P> <P>alt(date(date#(DateField, 'Format1')),&nbsp;date(date#(DateField, 'Format2')), ...)</P> <P>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.</P> <P>- Marcus</P> Wed, 15 Jun 2022 07:20:01 GMT https://community.qlik.com/t5/App-Development/DATE-FORMATES/m-p/1943802#M77769 marcus_sommer 2022-06-15T07:20:01Z