Quick background: My employer uses a rather odd (to others, it seems) date range for our Fiscal months - the 22nd to the 21st of each month. For example, Fiscal February runs 01.22.2012 to 02.21.2012.
Up until this point I’ve been able to use SYSDATE and simple functions to calculate dates in my reporting - they’ve just been the previous day, or previous 7 days, etc.
Now I need to work on reports that have this dynamic date range, and I’m not sure where to start.
What I’m looking for is something that will look at today’s date (03.02.2012, for example), and logically determine that the current fiscal month (and thus date range for the report) is 02.22.2012 - 03.21.2012. One of the nasty caveats to this is that on 03.22.2012, thereport range needs to stay 02.22.2012 - 03.21.2012, and it’s not until the 23rd that it would move on to the next fiscal month.
Is this even possible?