Months of Year

Format

January(StartTime [,TimeZone])

Note: This function applies to all the months of the year, from January - December. Substitute January for the appropriate month, as required.

Returns

Returns the time of the start of the month, occurring on or before the provided StartTime.

Inputs

StartTime: The time from which to calculate the start of the month.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: DateTime, Decimal, Integer, String

Note: You can use the Time() function to use a valid DateTime argument.

TimeZone: The geographical or UTC offset time zone (e.g. "Australia/Perth" or "UTC+08:00"). If not supplied, it assumes the configured calendar time zone. 
Behaviour: Optional
Dimension: SingleValue
Valid data types: String

How to format data types

Examples

Expression: January(Time(), "Australia/Perth")
Expression: February(Time() - 60, "UTC+08:00")
Expression: March(Time(), "Australia/Perth")
Expression: April(Time(), "UTC+08:00")

Release History

• Months of Year 4.6.5
  • Changed StartTime parameter to support MultiCollection values.
• Months of Year 4.0
  • Initial version