5 Replies Latest reply on Jan 10, 2014 3:32 PM by Brian Hirt

    Filter 12 months based on the latest date in the data?

    Todd Snell

      I'm trying to show the latest 12 months of data in a worksheet, but I'd like the "latest" 12 months to be based on the latest date in the "Activity Month" date field.

       

      As an example, the latest date in the field is 6/15/2013, which means it will show all records between 6/15/2012 and 6/15/2013.

       

      The "Anchor Relative to" feature in the date filter only allows a manual update... nothing dynamic.  Anyone have a good formula I could use to filter?

       

      I tried DATEDIFF('day',[Activity Month],today()) , but that anchors based on today's date, not the latest in the database.

       

      I can't use DATEDIFF('day',[Activity Month],max([Activity Month])) , because it's mixing aggregate and non aggregate arguments.

       

      Any help is appreciated!

       

      Todd