Is there any SQL that contains the current period which should be current month begin date and current month end date and similarly for the previous period which should be previous month begin date and previous month end date
Ex: Current Period :(03/01/2012-03/31/2012)
Previous Period :(02/01/2012-02/29/2012)
This is what I am trying to look for.I already have SQL's for current month begin and end dates also for previous month begin and end dates.
But, I am looking for something which is mentioned on the top.Is it possible to get SQL like this?
You can use calenders to get the min and max from within a month.