Get the last date of the previous quarter

[VPK_Access]

Hi,

Is there any formula to get the last date of the previous quarter.
I need to display the aging value and need to compare with this date. Any help please?

 

[apr pillai]

Try the following method:

x = Choose(Datepart("q",Date())-1,#3/31/2011#,#06/30/2011#,#09/30/2011#,#12/31/2011#)

Above is a simple method with constant values for Quarter ending dates. You can make date values dynamic by using DateSerial(03,31,year(date())) and for other Quarter ending date values.

 

[VPK_Access]

Thnanks a lot...that worked

 

[raskew]

Hi -

Here's another method that you might want to play with.

From the debug (immediate) window:

x = #1/15/2011#
? DateSerial(year(x), 3 * Int(((month(x)) - 1) / 3) + 1, 1) - 1
12/31/2010

Hope that helps. Best wishes:

Bob