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.
There's no way to do this, in Qlik or otherwise, because e.g. 10012021 could be either January 10th or October 1st and you have no way of distinguishing which.
Do you have another column that may tell you where that row of data came from? Like Country? Or country code in a phone number? That might make cleaning it up possible.
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.
Do you have another column that may tell you where that row of data came from? Like Country? Or country code in a phone number? That might make cleaning it up possible.
