Discussion Board for collaboration on QlikView Scripting.
I hope you can help with this quick query.
In my data I have several date fields. The format of the dates is (from what I can see) "Julian" dates set as 7 digits:
YYYY[day of the year in 3 characters]
Please can you help with a load script for this Date_of_Birth field, converting the above to "normal" dates in DD/MM/YYYY?
Go to Solution.
What does the date you are expecting for this? 1965166
May be this?
=TimeStamp( MakeDate( Floor(Date_of_Birth / 1000) ) + 1000 * Frac(Date_of_Birth / 1000) -1 )
May be like this?
Left(Date_of_Birth, 4) as Year,
Right(Date_of_Birth, 3) as Days;
LOAD * INLINE [
Left Join (Table)
IterNo() as Days,
Date(MakeDate(Year) + IterNo()-1) as Date
While YearStart(MakeDate(Year)) + IterNo() <= YearEnd(MakeDate(Year));
Wow this is much simpler