Date and Interval routines

This section contains routines that enable users to deal with dates.

Routines summary

• addMonths — Adds a number of months to a specified date, preserving the day of month where possible.
• currentDate — Returns the current date.
• day — Returns a number representing the day of month: 1-31.
• dayOfWeek — Returns the day of week.
• endOfMonth — Returns a date set on the last day of the month for the given date. Also sets hours / minutes / seconds / milliseconds to their respective maximum value.
• formatDate — Formats the given date into a date/time string accordingly to the given format expression.
• hour — Returns the hour of the provided date: 0-23.
• millisToDate — Converts milliseconds to a date.
• millisToInterval — Converts milliseconds to a time interval.
• minute — Returns the minutes of the provided date: 0-59.
• month — Returns a number representing the month of the provided date (1-12).
• monthName — Returns the month name of the provided date.
• parseDate — Returns the parsed date according to the format you provided. If parse fails, it will return a null date.
• second — Returns the seconds of the provided date: 0-59.
• startOfDay — Returns a date, but strips off the hours, minutes and seconds.
• startOfMonth — Returns a date set on the first day of the month for the given date. Also sets hours/minutes/seconds to 0.
• toDate — Creates a date value from the specified parameters.
• toJiraDateFormat — Displays the given date using Jira format.
• toRawWorkingInterval — Returns a date interval converted to the specified number of hours per day.
• toTimeZone — Converts a date to the specified time zone.
• week — Returns the week number in the year of the provided date.
• year — Returns the year of the provided date.

 See also

• Routines
• Syntax and types
• Variable resolution