Multiple date formats

[cristineg]

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.

[marcus_sommer]

You could just list all date-versions and the first valid numeric interpretation is taken, for example:

alt(date(date#(DATE, 'US-Format')), date(date#(DATE, 'EU-Format')), 'no valid date') as DATE

- Marcus