Issue in Makedate in QlikView

[Anonymous]

Hi Guys,

I have written the following code. Below is the screenshot

and following is the result

Can anyone Please help me...why this is happening..

I tried to check by sending the output of the TestDate Field into excel and i have found that they are existing with Timestamp. thats why they different on frontend.

Thanks in advance

[Anonymous]

Hi Gulshan,

from online help

MakeDate(YYYY [ , MM [ , DD ] ] )

Returns a date calculated from the year YYYY, the month MM and the day DD.

If no month is stated, 1(January) is assumed.

If no day is stated, 1 (the 1:st) is assumed.

Examples:

makedate(1999) returns 1999-01-01

makedate(99) returns 0099-01-01

makedate(1992,12) returns 1992-12-01

makedate(1999,2,14) returns 1999-02-14

Regards,

Rajan

[its_anandrjs]

Try to change the variable with this and make Numeric date also like Date#

Let vDumpDate = Floor(NUM(Date(Date#(Makedate(2017,09,01),'DD/MM/YYYY'),'DD/MM/YYYY'));

[Anonymous]

Hi Anand,

Thanks in advance...I tried it but didn't works

[tresesco]

What if you try like: Date(Floor(MonthEnd('$(vDumpDate)'), 'DD/MM/YYYY') as Test Date

[kavita25]

Try with simple logic:

let vDumpDate=Date((Makedate(2017,09,01)),'DD/MM/YYYY');

Date(Monthend('$(vDumpDate)'),'DD/MM/YYYY') as TestDate

Hope it helps.

[its_anandrjs]

In variable try only this

Let vDumpDate =Date(Makedate(2017,09,01),'DD/MM/YYYY')

[sunny_talwar]

Why go through the hassle if your variable will store the date in number format.... try this

LET vDumpDate = Floor(MakeDate(2017, 9, 1));

and then this

[ABC]:

LOAD ....

     Date(Floor(MonthEnd($(vDumpDate))), 'DD/MM/YYYY') as TestDate

FROM ...

[Anonymous]

Thanks Guys now it has been resolved

[sunny_talwar]

What was the issue?