Date Ranges 1

[ganjass]

cr8
sql2000

Hi All

I need a report to use 2 dateranges that sum all accounts for the last year to the start of the last full month, and the start of this year to the start of the lastfullmonth

ie for this month i would need the daterange of last year to, but not including July, ie the end of june, and the start of this year to the end of june

Thanks in advance

 

[bdreed35]

Try this in your Record Selection Criteria:

{table.date} in minimum(lastyearYTD) to dateadd("m",-1,minimum(LastYearMTD))-1
OR
{table.date} in minimum(YearToDate) to dateadd("m",-1,minimum(MonthToDate))-1

~Brian

 

[ganjass]

thats along the lines of what i was thinking, nice one