Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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?

Tags (1)
1 Reply

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

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

Community Browser