Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
IN oracle db I have a load date of below format in the screenshot .
And when loaded into qlikview the out put date is like the below
Now during loading the data into qlikview I am using this condition
Where Date(Load_Date)>10/31/2020
But still i get the whole data . How can i handle this and load the data aftr 10/OCt/2020 in qlikview .
Thanks in Advance
Hi @smilingjohn
Try like below
Where Floor(Load_Date)> Floor(MakeDate(2020,10,31));
Hi @smilingjohn
Try like below
Where Floor(Load_Date)> Floor(MakeDate(2020,10,31));
Thanks @MayilVahanan
Can you please tell me what does make date do here ?
ANd yes this is working ,if you can please explain me how it is working it would be a good lesson for me for the future .
Hi @smilingjohn
Here, its important is floor() function which convert timestamp to numeric.
MakeDate() function returns a date based on passing year, month & day.