prevQtr Function

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


date prevQtr(date date)

Parameter

Description

date

The date to match in the previous quarter.

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

  • prevQtr(30\04\1998); //Returns the date 30/01/1998.

  • prevQtr(29\05\1996); //Returns the date 29/02/1996, because 1996 is a leap year.

Community Additions

ADD
Show: