1 Reply Latest reply: Sep 25, 2014 11:19 AM by Marco Wedel RSS

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

    sneha jha

      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?