Date Filter in a Generic Inquiry

In Acumatica, creating a filter to show data for the last seven days, last month, or to forecast next month can be done by utilizing relative date keywords in combination with the appropriate operator in the filter condition.

However, to create more complex relative date filters (like "the last seven days"), you'll need to set up a pair of conditions to form a date range.

Here's how you can do it:

1. Last seven days: To get the data for the last seven days, create two conditions:

   • Condition 1: [YourDateField], Greater Or Equal, @Today-7.
   • Condition 2: [YourDateField], Less Than, @Today.

2. Last Month: If you want to get the data for the previous month, use:

   • Condition 1: [YourDateField], Greater Or Equal, @Month-1.
   • Condition 2: [YourDateField], Less Than, @Month.

3. Next Month Forecast: If you want to forecast the next month, use:

   • Condition 1: [YourDateField], Greater Or Equal, @Month+1.
   • Condition 2: [YourDateField], Less Than, @Month+2.

The @Today-7 and @Month-1 syntax you mentioned works as expected in my experience. If this isn't the case, please verify that you have the latest updates or patches for your version of Acumatica.

Please note that these filters will work dynamically. Every time you run the GI, it will calculate the dates based on the current date (for @Today) or the current month (for @Month).