prevQtr Function

Retrieves the date in the previous quarter that corresponds most closely to a specified date.


date prevQtr(date date)

Parameter

Description

date

The date to match in the previous quarter.

The closest match to date that is found in the previous quarter.

// Returns the date 30/01/1998.
prevQtr(30\04\1998);
 
// Returns the date 29/02/1996 (leap year).
prevQtr(29\05\1996);

Community Additions

ADD
Show: