Filter by Date

[#1]

I have a date field which is month day year. I want to see only those records where this date field is the in Inv Month and Inv Year selected. How would do that?

[erichshiino]

Let's us say that your field is called DATE.

at the end of the script you can make

Load distinct DATE,

MONTH(DATE) AS InvMonth,

Year(DATE) as InvYear

Resident YourTable

Maybe QlikView didn't recognize your field as a date yet. So, if your field is MMDDYYYY, the script would be:

Load distinct DATE,

LEFT(DATE,2) AS InvMonth,

right(DATE,4) as InvYear

Resident YourTable