DIM filter question
TSasha Smith
Posts: 27,299
in The Commons
Is there anyway to filter products bought in a certain year? Like show only items ordered in 2016 or 2011 or etc? Or how about a certain month like March 2016 or October 2011 or whatever? I was curious about about how many items I got in each period. I know it is not accurate as some products have multiple downloads.

Comments
For sure. In the filter field, enter date::YYYY-MM-DD for a single day, or date::[YYYY-MM-DD, YYYY-MM-DD] for a range of dates, from/to.
There are symbols for days, weeks, months and years. It is quite clearly explained in the Install Manager Reference Guide - Advanced Filtering - Date (Time). A little technical, but not too much. The built-in filters, eg., for years, look like this:
This year (this calendar year)
date::[%0_YEARS%,%0_YEARS%]
Last year (last calendar year)
date::[%1_YEARS%,%1_YEARS%]
Last year start (last year + this year-to-date)
date::%1_YEARS%
If you want to go back 2 years (2017, 2018 + year-to-date) put date::%2_YEARS
If you want to look at a previous year (say, 2017), put date::[%2_YEARS%,%2_YEARS%]
For 2016 and 2017 put date::[%3_YEARS%,%2_YEARS%]
Similarly for months, weeks, days...
ETA: Default is Order Date, but you can modify it for Package date or Install date.
Rob says