Discussion board where members can get started with QlikView.
Im new in QV.
well i have 2 fields like this.
1, 2, 3, 4, 5, 6, 7,...
1, 2, 3, 4, 5, 6, 7, 8...
i have to make them date.
year 1 is mean 2001, 2 = 2002...
how should i do this. please anyone help me.
Go to Solution.
MAKEDATE(YourYear + 2000, YourMonth) should deliver the 1st of each month.
well i tried makedate() but its give me 3/1/2001 something like that so thought its not working well.
i figure it out. that date format isnt right. so i used
now its look like give me correct date format.
sorry for typed newbie question.
Thank you peter
The MAKEDATE should already deliver you a date in the format as in the initial lines of the script under
SET DateFormat = ....
If you wish to change all your date-display as YYYYMMDD, you should be able to write this into the above statement.