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]

While Loading vDumpDate as a Column. I Just put Date and Date# in front of it.

[its_anandrjs]

Good one you got now .

[Anonymous]

Yes...Thanks

[sunny_talwar]

You add Date#() to a number variable and it worked? That is strange... but as long as you get what you wanted

[its_anandrjs]

Close the thread now for references.

[Anonymous · Accepted solution]

I Just want that same dates occur only once but in my case it occurs twice.

and Yes after adding Date# and Date it works because initially QlikView taken the dates as two different dates because of time stamp. I was too shocked why the timestamp has been generated. but after applying the above functions it return only date w/o any timestamp

[sunny_talwar]

Can you post the exact load statement script you used for test date? Also, on the similar note... did you give this a shot?

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

and then this

[ABC]:

LOAD ....

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

FROM ...

[Anonymous]

[sunny_talwar]

I would not have expected this to have worked... but I may not know about this feature... I will test this out at my end and I may get to learn something new

[sunny_talwar]

Thanks for sharing