How to manually add the month and year to a day

[#1]

Hello everyone,

I have a table where I only have the day (1 to 31)

rejection	TOTAL	product	Day
absence		TRI	25
piece jointe		TRI	9
manque page		TRI	9
justificatif		TRI	24
manque page		TRI	24

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 !

[Gysbert_Wassenaar · Accepted solution]

MakeDate(2016,3,Day) as dateTest

[MindaugasBacius]

Use a Makedate statement.

Makedate(2016, 3, Day) as Date

[sunny_talwar]

Try like this:

Date(MakeDate(2016, 3, Day)) as dateTest

[#5]

Perfect ! That was exactly the function I was looking for