Skip to Content
0
Former Member
Mar 20, 2009 at 02:37 PM

quarterly start and end dates

1814 Views

Hi folks,

I need to find the start and enddates of current quarter and last four quarters based on the current date.

For ex:

current date 03/20/09 means current quarter startdate 01/01/2009 and enddate 03/31/2009

current quarter -minus 1 = 10/01/2008 to 12/31/2008

current quarter -minus 2 = 07/01/2008 to 10/31/2008

current quarter -minus 3 = 04/01/2008 to 06/30/2008

current quarter -minus 4 = 01/01/2008 to 03/31/2008

based on the current date i need to dtermine the start and end dates of last five quarters.

Is there a FM that I can make use of?

Thanks,

VG