Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I read text as dates

However the year comes up like 56989 . What am I doing wrong?

8 Replies
Gysbert_Wassenaar

Probably using the wrong date format string. Post the text of a date here and somebody can show you what to use.


talk is cheap, supply exceeds demand
Not applicable
Author

20140518
20140702
20140911

This an example of the format I try to read as Date (Periode) as Periode,

Not applicable
Author

I doesn't really show here but in the excel sheet the numbers are stored as text.

Gysbert_Wassenaar

Date will treat the number as the number of days since 31-12-1899. What you need is to treat Periode as a string using the date# function: date#(Periode, 'YYYYMMDD')


talk is cheap, supply exceeds demand
Not applicable
Author

That worked 100% .. Thanks!!!

Not applicable
Author

However there is a 0 at the top for all the missing cases...

andrewpettit
Partner - Creator
Partner - Creator

If you only want the year from the format you provided why not simply do "Left( Periode , 4 )"?

Not applicable
Author

I will check it out when I got time! Thanks