Hi there,
I was wondering if anyone can assist with a syntax that will select data from the last full month less twelve months.
So in current terms that would represent 01/06/2010 - 30/06/2010 less twelve months. This would deliver a final result of data in the range of 01/06/2009 - 30/06/2009.
Obviously its easy to draw the data using parameters, but due to the nature of my report I can't use this method.
Is it possible to use LastFullMonth in combination with the the DateAdd or DateDiff function. That way I could say give me the last full month less 12 months??
IP Logged
