Issue with Date format

[podge2019]

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

[jwjackso · Accepted solution]

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.

[podge2019]

Super, thanks @jwjackso 

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

Thanks for the guidance