Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
However the year comes up like 56989 . What am I doing wrong?
Probably using the wrong date format string. Post the text of a date here and somebody can show you what to use.
20140518 |
20140702 |
20140911 |
This an example of the format I try to read as Date (Periode) as Periode,
I doesn't really show here but in the excel sheet the numbers are stored as text.
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')
That worked 100% .. Thanks!!!
However there is a 0 at the top for all the missing cases...
If you only want the year from the format you provided why not simply do "Left( Periode , 4 )"?
I will check it out when I got time! Thanks