Making a year-to-date query

March 25 2011 by mike in Example |No Comments

Question: I want to set up a YTD figure so the figures include every complete calendar month for the year (e.g. if the date today was April 2nd, I would need the figures for Jan, Feb and March only)
Answer: The simplest solution would be to make a query for the “LastCalendar 2 Months” and save [...]