Filter list data on last month

Hi everyone,

I am trying to work with advanced filters to extract data from a list : I would like to filter objects created last month, and save that request as a view, for further use in the upcoming months.

I found out that date filter fields accept keywords such as TODAY, MONTH, WEEK, which translate in regular filtering expressions (MONTH translates in 01/05/2015…31/05/2015).

I wish there was a LASTMONTH keyword, that would dynamically translate into 01/04/2015…30/04/2015 but i can’t find it.

Can you tell me if such a keyword exists, or if there is another way to achieve my filter ?

(In NAV 2013r2) Try “month-1m”:


  • then save this as a view.

It works perfectly, thank you !