Thanks for the help thus far, but none thus far answer my question really.
I want to be able to use YTD & QTD in the functions inXXXtodate so that I can easily pick out previous and future time periods. My understanding of the function is from the Ref Manual.
InQuarterToDate (date, basedate , shift [, first_month_of_year =1])
So I am not sure why I can get a year to date or quarter to date figure with a start of year for July. I want my YTD 7 to show 3200 from the above table assuming my start of year was in July?
Does that make sense?