PFC DateTime Service (n_cst_datetime)

The Date/Time service provides methods to perform calculations with dates.
It includes the following features:

List of Functions Available in Datawindow Expressions

Expressions are most commonly used to create datawindow column property expressions. But the are also used to create filter and find strings.

Working with Dates

Day of the week

DayNumber(date)

Returns an integer (1-7) representing the day of the week of date. Sunday is day 1, Monday is day 2, and so on.

Day of month

Day(date)

Returns the day of the month 1-31.