EXAMPLE - Day of Functions

This example illustrates how you can apply functions to derive day-of-week values out of a column of Datetime type:

• WEEKDAY - returns numeric value for the day of the week for source Datetime values. See WEEKDAY Function. 
• WEEKNUM - returns the numeric value for the week within the year for source Datetime values. See WEEKNUM Function.
• DATEFORMAT - can be used to format Datetime values in many different ways. See DATEFORMAT Function.

Source:

Transform:

The following generates a numeric value for the day of week in a new column:

derive type:single value: WEEKDAY (myDate) as:'weekDayNum'

The following generates a full text version of the name of the day of the week:

derive type:single value:DATEFORMAT(myDate, 'EEEE') as:'weekDayNameFull'

The following generates a three-letter abbreviation for the name of the day of the week:

derive type:single value:DATEFORMAT(myDate, 'EEE') as:'weekDayNameShort'

The following generates the numeric value of the week within the year:

derive type:single value: WEEKNUM (myDate) as:'weekNum'

Results: