Filtering on date to get particular month data

[PM2]

Hi community,

Please help me in getting the output of a particular month from an excel file having data from 2001-2020.

I want to extract only Jan 2020 data from the file.

Below is the script have written

Load

Opendate

Feom xls file

Where Opendate>=Date#('01-Jan-20','DD-MMM-YY')

This is not giving me only jan 20 month data.

[Vegar]

Your script is loading all data larger than January 1 2020.

You can do like this to set an upper and lower limit. (Assuming that Opendate is a date field in excel)

LOAD *

WHERE MonthName(Opendate)= MonthName(makedate(2020,1))

[PM2]

Hi Vegar,

Thanks but 0 lines fetched on reloading.

In my excel the date is in cuatom format dd-mmm-yy.

I have script

Load

*Resident Data

Where ( in condition on getting only jan month 20 data). 

On applying where condition mentioned by you 0 lines fetched. I am sorry but new to qlikview.😟

[PM2]

Hi @Vegar 

not getting the output. 0 lines fetched. Column in excel in which dates mentioned is in custom format DD-MMM-YY.

Please help😟

[Vegar]

Could you post a sample excel and QV-docukent? It does not need to be the same data, but it needs a sample where the date fileter issue can be tested.