Date restriiton

[smilingjohn]

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

[MayilVahanan · Accepted solution]

Hi @smilingjohn 
Try like below

Where Floor(Load_Date)> Floor(MakeDate(2020,10,31));

[smilingjohn]

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 .

[MayilVahanan]

Hi @smilingjohn 

Here, its important is floor() function which convert timestamp to numeric. 
MakeDate() function  returns a date based on passing year, month & day.