Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
While Loading vDumpDate as a Column. I Just put Date and Date# in front of it.
Good one you got now .
Yes...Thanks
You add Date#() to a number variable and it worked? That is strange... but as long as you get what you wanted
Close the thread now for references.
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
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 ...
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
Thanks for sharing