Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
podge2019
Contributor III
Contributor III

Issue with Date format

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.

podge2019_2-1617819083620.png

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

podge2019_0-1617819064475.png

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

Thanks

1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

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.

 

Untitled.png

View solution in original post

2 Replies
jwjackso
Specialist II
Specialist II

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.

 

Untitled.png

View solution in original post

podge2019
Contributor III
Contributor III
Author

Super, thanks @jwjackso 

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

Thanks for the guidance

podge2019_0-1617823038606.png