Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How to manually add the month and year to a day

Hello everyone,

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

    

rejection TOTALproductDay
absence TRI25
piece jointe TRI9
manque page TRI9
justificatif TRI24
manque page TRI24

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 !

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How to manually add the month and year to a day

MakeDate(2016,3,Day) as dateTest


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: How to manually add the month and year to a day

MakeDate(2016,3,Day) as dateTest


talk is cheap, supply exceeds demand
MindaugasBacius
Valued Contributor III

Re: How to manually add the month and year to a day

Use a Makedate statement.

Makedate(2016, 3, Day) as Date

Re: How to manually add the month and year to a day

Try like this:

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

Not applicable

Re: How to manually add the month and year to a day

Perfect ! That was exactly the function I was looking for