Filtering on date to get particular month data

[PM2]

Hi,

IN EXCEL I HAVE DATE FORMAT IN CUSTOM AS DD-MMM-YY from 2001 to 2020

IN QLIKVIEW I WANT EXTRACT DATA ONLY FOR Jan 20 month.

Load

*Resident Data

Where MonthName(Opendate)= MonthName(MakeDate(20,'Jan'))

0 lines fetched. Please help in getting the output.

[ashishkalia]

Hi @PM2 ,

In your condition:
Where MonthName(Opendate)= MonthName(MakeDate(20,'Jan'))
In Year: Instead of 20 put 2020
In Month: Put Month Number without any quotes.

Where MonthName(Opendate)= MonthName(MakeDate(2020, 01))

This will help.

Regards,
AK

[Brett_Bleess]

Did Ashish's suggestion work for you?  If so, be sure to close out your thread by using the Accept as Solution on his post to give him credit for the help and let the other Members know it worked.

You may want to check the following Design Blog posts too, might be helpful with things:

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

If you want to look around yourself, use the following link to search just that area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett