@Month (Formula Language)

Syntax

@Month( time-date )

Parameters

time-date

Time-date or time-date list. The value with the month that you want to extract.

Return value

month

Number or number list. The number of the month. Returns -1 if the time-date provided contains only a time value and not a date.

Usage

If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

Examples

1. This example returns 1.

   @Month([1/15/88])

2. This example returns 1 and 2 in a list.

   @Month([1/15/88] : [2/15/88])

3. This example returns 12 if it is December.

   @Month(@Now)

4. This example returns 2 if it is any date in December other than the 30th or the 31st. If it is December 30th or 31st, returns 3.

   @Month(@Adjust(@Now;2;2;2;2;2;2))

5. This formula returns a formatted date string based on the contents of the dueDate field. For example, if dueDate contains "06/26/95" the formula returns June 26, 1995. If dueDate contains "01/24/96 3:40:43 P.M.," the formula returns January 24, 1996.

   space:= " ";
   comma:=",";
   month:=@Select(@Month(dueDate);"January";"February";"March";
   "April";"May";"June";"July";"August";"September";"October";
   "November";"December");
   day:=@Text(@Day(dueDate));
   year:=@Text(@Year(dueDate));
   month + space + day + comma + space + year