topic Issue with Date format in QlikView

Issue with Date format

podge2019 — Wed, 07 Apr 2021 18:12:45 GMT

Hi,

Working with some date data and looking for some assistance.

Have a spreadsheet or three with multiple versions of Policy Start Date.

To try to clean this up in the script I have this long winded entry in my script to capture all the formats.

It does does the job except for one rogue date 19122005 which then comes into QlikView as 08/04/54254

Any guidance on how I can change my script to capture this date? Its one rogue date out of thousands!!

Thanks

Re: Issue with Date format

jwjackso — Wed, 07 Apr 2021 18:37:28 GMT

The first case in the alt function converts 19122005 to a number that is used in the date function. The date is calcualated as 19,122,005 days since Dec 30, 1899.

The date never gets to the 'DDMMYYYY' date format.

Re: Issue with Date format

podge2019 — Wed, 07 Apr 2021 19:17:46 GMT

Super, thanks @jwjackso

Changed my script to this and it done the trick....rogue date is gone.

Thanks for the guidance