CMOY( ) function

Returns the name of the month of the year for a specified date or datetime. Abbreviation for "Character Month of Year".

Syntax

CMOY(date/datetime, length)

Parameters

Name Type Description
date/datetime

datetime

 The field, expression, or literal value to return the month name for.
length

numeric

A value between 1 and 9 that specifies the length of the output string. To display abbreviated month names, specify a smaller value.

Output

Character.

Examples

Basic examples

Returns "December":

CMOY(`20141231`, 9)

Returns "Dec":

CMOY(`20141231 235959`, 3)

Returns the abbreviated month name for each value in the Receipt_timestamp field:

CMOY(Receipt_timestamp, 3)

Returns the full month name for each value in the Invoice_date field:

CMOY(Invoice_date, 9)

Returns the full name of the month 15 days after each value in the Invoice_date field:

CMOY(Invoice_date + 15, 9)

Remarks

Parameter details

A field specified for date/datetime can use any date or datetime format, as long as the field definition correctly defines the format.

If the length parameter is shorter than the month name, the month name is truncated to the specified length. If the length parameter is longer than the month name, the month name is padded with blank spaces.

Specifying a literal date or datetime value

When specifying a literal date or datetime value for date/datetime, you are restricted to the formats in the table below, and you must enclose the value in backquotes – for example, `20141231`.

Do not use any separators such as slashes (/) or colons (:) between the individual components of dates or times.

  • Datetime values – you can use any combination of the date, separator, and time formats listed in the table below. The date must precede the time, and you must use a separator between the two. Valid separators are a single blank space, the letter 't', or the letter 'T'.

  • Time values – you must specify times using the 24-hour clock. Offsets from Coordinated Universal Time (UTC) must be prefaced by a plus sign (+) or a minus sign (-).

    Example formats

    Example literal values

    YYYYMMDD

    `20141231`

    YYMMDD

    `141231`

    YYYYMMDD hhmmss

    `20141231 235959`

    YYMMDDthhmm

    `141231t2359`

    YYYYMMDDThh

    `20141231T23`

    YYYYMMDD hhmmss+/-hhmm

    (UTC offset)

    `20141231 235959-0500`

    YYMMDD hhmm+/-hh

    (UTC offset)

    `141231 2359+01`

    Note

    Do not use hh alone in the main time format with data that has a UTC offset. For example, avoid: hh+hhmm. Results can be unreliable.

     

Related functions

If you need to return the month of the year as a number (1 to 12), use MONTH( ) instead of CMOY( ).

[ Back to top ]

ACL Scripting Guide 14.1