https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1915700#M1227453 <P>You could just list all date-versions and the first valid numeric interpretation is taken, for example:</P> <P>alt(date(date#(DATE, 'US-Format')), date(date#(DATE, 'EU-Format')), 'no valid date') as DATE</P> <P>- Marcus</P> Thu, 07 Apr 2022 08:35:33 GMT marcus_sommer 2022-04-07T08:35:33Z https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1915614#M1227449 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4" style="margin: 12px 0px 0px 8px; padding: 5px 16px 5px 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: medium; line-height: inherit; font-family: IBMPlexSans, Arial, sans-serif; vertical-align: baseline; max-width: 800px; color: #878a8c;" data-click-id="text"> <DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root" style="margin: 0px 0px -1px; padding: 0px 0px 1px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 14px; line-height: 21px; font-family: 'Noto Sans', Arial, sans-serif; vertical-align: baseline; word-break: break-word; overflow: auto; color: #1a1a1b;"> <P class="_1qeIAgB0cPwnLhDF9XSiJM" style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">Just wondering if there is any script that will help me distinguish European date format ddmmyyyy from US date format mmddyyyy? I have an excel document with a date column that contains the two formats(the column itself is formatted as general). Instead of changing excel, is there qlikview script that would allow me to create a new field containing a single format? Thanks.</P> </DIV> </DIV> <DIV class="_1hwEKkB_38tIoal6fcdrt9" style="margin: 0px; padding: 4px 16px 0px 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: medium; line-height: inherit; font-family: IBMPlexSans, Arial, sans-serif; vertical-align: baseline; display: flex; align-items: center; flex-wrap: wrap-reverse; justify-content: space-between; color: #878a8c;"> <DIV class="_3-miAEojrCvx_4FQ8x3P-s" style="margin: 0px; padding: 0px 8px 0px 4px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: bold; font-stretch: inherit; font-size: 12px; line-height: 16px; font-family: inherit; vertical-align: baseline; align-items: stretch; display: flex; flex-direction: row; overflow: hidden; flex-grow: 1;">&nbsp;</DIV> </DIV> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1915614#M1227449 cristineg 2026-01-26T21:26:37Z https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1915700#M1227453 <P>You could just list all date-versions and the first valid numeric interpretation is taken, for example:</P> <P>alt(date(date#(DATE, 'US-Format')), date(date#(DATE, 'EU-Format')), 'no valid date') as DATE</P> <P>- Marcus</P> Thu, 07 Apr 2022 08:35:33 GMT https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1915700#M1227453 marcus_sommer 2022-04-07T08:35:33Z