https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1769043#M717365 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">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> Wed, 16 Dec 2020 17:03:31 GMT lokaupdes34 2020-12-16T17:03:31Z https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1769043#M717365 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">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> Wed, 16 Dec 2020 17:03:31 GMT https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1769043#M717365 lokaupdes34 2020-12-16T17:03:31Z https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1769045#M717366 <P>If it can be in either format, how do you tell if 12012019 is January 12th or December 1st?</P> Wed, 16 Dec 2020 17:11:18 GMT https://community.qlik.com/t5/QlikView/Multiple-date-formats/m-p/1769045#M717366 Nicole-Smith 2020-12-16T17:11:18Z