Filter on date greater than particular date

[PM2]

Hi All, 

I want to put filter on date in script.

Have written the below code

Load

Open_date,

From (xls file)

Where

Open_date>='01-Jan-20';

But i am not getting the correct output. I am new to qlikview and please help me on this.

[Vegar · Accepted solution]

Try this:

LOAD
  Open_date
FROM (xls file)
WHERE
  Open_date >= Date#('01-Jan-20', 'DD-MMM-YY');

[PM2]

Hi, 

Thanks for support

I have data from 2001 to Jan 2020 and only want Jan 2020 to generate output file.

However, while running below code giving me all the rows from 2001.

[PM2]

Hi,

Please help urgently...

I have data from 2001 to 2020in xls file.

And want to generate output file containing only Jan 2020 data filter using qlikview.

Load

Open_Date

From (xls) file

Where

Open_date>=Date#('01-Jan-20','DD-MMM-YY);

Not giving me correct output of containing only jan month data. Its giving me full report seems filter is not getting captured.

[Brett_Bleess · Accepted solution]

Little confused on things being marked solved when the post is asking for further assistance, so dropping a couple other links that may be of help:

https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

I am going to change the marked solution to Vegar's post as my hunch is you figured out what you had done incorrectly based upon his post and did not take the time to write-up exactly what was wrong.

Regards,
Brett