CDOW( ) function

Returns the name of the day of the week for a specified date or datetime. Abbreviation for “Character Day of Week”.

Syntax

CDOW(date/datetime, length)

Parameters

date/datetime

Datetime. The field, expression, or literal value to return the day name for.

length

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

Output

Character.

Remarks

You can use the CDOW( ) function to determine which day of the week a date falls on, and return the name of the day.

Use the DOW( ) function if you want to return the day of the week as a number (1 to 7). Use the DAY( ) function if you want to return the day of the month as a number (1 to 31).

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

When specifying a literal date or datetime value for the date/datetime parameter, you are restricted to the formats in the table below, and you must enclose the value in backquotes – for example, `20141231`. For datetime values, you can use any combination of date, separator, and time formats. The date must precede the time, and you must use a separator between the two. Times must be specified using the 24-hour clock. Offsets from Coordinated Universal Time (UTC) must be prefaced by a plus sign (+) or a minus sign (-). Do not use any separators such as slashes (/) or colons (:) between the individual components of dates or times.

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

Date formats

Separator formats

Time formats

Examples

YYYYMMDD

single blank space

hhmmss

`20141231`

YYMMDD

the letter ‘t’

hhmm

`20141231 235959`

the letter ‘T’

hh

`141231 2359`

 

+/-hhmm

(UTC offset)

`141231t23`

+/-hh

(UTC offset)

`141231t235959-0500`

(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.)

`141231T2359+01`

Examples

Example Return value

CDOW(`20141231`, 9)

“Wednesday”

December 31, 2014 falls on a Wednesday.

CDOW(`20141231 235959`, 3)

“Wed”

December 31, 2014 falls on a Wednesday.

CDOW(Invoice_date, 9)

The full day name for each value in the Invoice_date field

CDOW(Receipt_timestamp, 3)

The abbreviated day name for each value in the Receipt_timestamp field

Add a field identifying the days of the week for dates

You can use the CDOW( ) function to create a computed field that identifies the days of the week for all the dates in a date field. Once you have created the computed field, you can add it to the view beside the date column.

DEFINE FIELD Name_of_Day COMPUTED CDOW(Trans_Date, 3)
Related reference
DOW( ) function
DAY( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback