Discussion board where members can get started with QlikView.
I have a table where I only have the day (1 to 31)
And I want to add the month and year in the load script. I tried something like that :
Date(Day/03/2016,'DD/MM/YYYY') as dateTest
But as result I have 30/12/1899.
If someone have an idea how to do it, that would be great !
Go to Solution.
MakeDate(2016,3,Day) as dateTest
Use a Makedate statement.
Makedate(2016, 3, Day) as Date
Try like this:
Date(MakeDate(2016, 3, Day)) as dateTest
Perfect ! That was exactly the function I was looking for