I am working on creating a custom report for our contracts. Our fiscal year runs from 4/1 of the current year to 3/31 of the following year. I was going to base my report of the existing "this year" functioanlity and then do a calculation to add 3 months to the where clause for the date to compensate for the offset of our fiscal year period.

 

However, when I looked at the base query for the "this year" filter I noticed that the query shows

 WHERE  (((longtodate(mcdt.TODATE) >= 1388552400000) which leads me to believe the report is hard coded for the current year. If we leave a report with the "this year" criteria, come 1/1/15 will it automatically adjust to the year 2015 filter criteria instead of 2014? It almost seems like you would have to rebuild the report each year to adjust for the current year value in the where clause of the query.

 

If this is the case then I would just manually select the dates for our fiscal year and try to remember that every year I need to rebuils these reports (not an ideal solution at all).