Date filtering in reporting

[Zerker]

I am trying to set up a 2 qlik report filters one that filters to the last month. And one that filters to the previous year.  The expressions i try in the actual app works, but not in the reporting filter.

Prior year

=[Repair Date]>=(AddMonths(Today(),-12))

for this one when i just do = and no > it will bring back data from current date from last year

Previous month 

MonthStart(Date([Invoice Month])) = MonthStart(AddMonths(Today(), -1))

[Andrea_Bertazzo]

hi @Zerker

If you need to filter the last year, you can use something like this:
Year([Repair Date]) = Year(Today()) - 1

If you need to filter the latest 12 months, the formula seems fine, but there may be incompatibilities related the the format of the [Repair Date] filed. 
Maybe you can force it to a date format:
=Date([Repair Date])>= Date((AddMonths(Today(),-12)))

[Zerker]

Neither one worked.  Below is the format of my date field

[Lech_Miszkiewicz]

Hi @Zerker 

Your screenshot is showing mask in which your field is loaded. You need to screenshot us more details in there (tags) which would indicate if field is actually loaded as date (and therefore can be filtered as date) or maybe an asci text and cannot. This is critical to for the filter to be properly configured.

Also, have you selected search option?

I have created test app and applied your filter and it works on my end so you may need to either double check your syntax or make sure you follow the steps provided above to check what is not working. Another thing is whether or not you are applying any other filters? They may be affecting search string by data association!

Cheers

Lech