Date and Interval Functions

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

Functions 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.
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.

Peacock