Minimum Version Required: 23.01
Pre-Conditions
Required Permission - FusionEdit
Recommended Fusion I/II Certification
Steps
Week
Extracts the week number of the year (1-54) from a date or timestamp.
Syntax
WEEK(Date Value)
Arguments
DateValue:
A date or datetime that you want to extract the week number from.
Example
WEEK(10/1/19) = 40
Month
Extracts the month number of the year (1-12) from a date or timestamp.
Syntax
MONTH(DateValue)
Arguments
DateValue:
A date or datetime that you want to extract the month number from.
Example
MONTH(10/1/19) = 10