MONTH function

Evaluates a date expression and returns a month INTEGER value from 1 to 12, inclusive.

Syntax

MONTH ( date )
MONTH ( datetime-expression )
date
A date expression where you want a month value.
datetime-expression
An expression that evaluates to a DATETIME or DATETIME-TZ. The MONTH function returns the month of the date part of the DATETIME or DATETIME-TZ value.

Example

This procedure displays all the Orders that have a PromiseDate in a month that has passed, and whose ShipDate field is the Unknown value (?), which is the initial value of the ShipDate field:

r-mon.p

FOR EACH Order NO-LOCK:
  IF (MONTH(Order.PromiseDate) < MONTH(TODAY) OR
    YEAR(Order.PromiseDate) < YEAR(TODAY)) AND Order.ShipDate = ? THEN 
    DISPLAY Order.OrderNum LABEL "Order Num" Order.PO LABEL "P.O. Num"
      Order.PromiseDate LABEL "Promised By"
      Order.OrderDate LABEL "Ordered" terms
      WITH TITLE "These orders are overdue".
END.

See also

ADD-INTERVAL function, DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, INTERVAL function, ISO-DATE function, MTIME function, NOW function, TIME function, TIMEZONE function, TODAY function, WEEKDAY function, YEAR function, YEAR-OFFSET attribute