Changing the default date range of the Quarter functions

[Alundil]

CR9 Pro
Oracle 8i DB

I am curious, is there any way to modify the date range of the built in Calendar1stQtr to reflect dates that more closely resemble fiscal year/quarter ranges? IE: 9-01-04 to 8-31-05 as an example of FY05

 

[bdreed35]

If you wanted to adjust the Calendar1stQuarter function you could do it like this:

{table.date} in dateadd("m",-4,minimum(Calendar1stQtr)) to dateadd("m",-1,minimum(Calendar1stQtr))-1

This would give you a first quarter of 9-01-03 through 11-30-03, according to what you posted.

~Brian