set date format in qlikview script to check the reload in specific date format only

[#1]

How to validate data if the loaded data for a given date format has to be in the specified date format ?

If the date format is not in the standard format as we wanted, the reload will fail.

For example I have set the date  in the script Date(Date, "MM/DD/YYYY" ) and in case the date is not in this format, rather in some other format such as DD.MM.YYYY, the reload will fail and throw the error?

Any idea n this will be highly appreciated?

[MarcoWedel]

You could also try to load different formats like:

Alt(Date(Date, "MM/DD/YYYY" ),Date(Date, "YY-MM-DD" ),Date(Date, "DD.MM.YYYY" ))

regards

Marco