prevQtr Function [AX 2012]

Updated: December 11, 2009

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: