Recently, a bunch of new Date Comparisons were added to Dynamics for "Older Than X Days/Weeks/Months/Years".

However, the new addition did not include an option for Fiscal Years.

Consequently, there is no way to construct a query that finds records where a date is between 3 and 5 Fiscal Years in the past.

I would like additional comparison options for date fields added:

  • Older Than X Fiscal Years
  • Between X and Y Fiscal Years (either different options for "in the past" vs "in the future", or allow for negative numbers to represent the past).

Also, we should have the inverse of "Older Than X" for "Farther out Than X Days/Weeks/Months/Years/Fiscal Years".

Category: General