Admin Manual / Workflow Management / Formula / Date Functions References
Date Functions References

See the list of date and time functions you can use with your workflows below.

Function

Description

Date.Now

Returns the current date and time.


Usage:

${Date.Now}


Example:

${Date.Now + 7wd} will return the next 7 working days from the current date. 

Date.Today

Returns the current date/time as a date/time data type. 


Use

${Date.Today}


Example:

${Date.Today + 7d} will return the next 7 days from the current date.

Date.ThisWeek

Returns the current week number. 


Use

${Date.ThisWeek}


Example:

${Date.ThisWeek + 1} will return the next week number.

Date.ThisMonth

Returns the current month number from 1 to 12. 


Use

${Date.ThisMonth}


Example:

${Date.ThisMonth -1} will return the last month number.

Date.ThisQuater

Returns the current quarter number. 


Use

${Date.ThisQuater}


Example:

${Date.ThisQuater + 2} will return the next two quarter number.

Date.ThisYear

Returns the current year. 


Use

${Date.ThisYear}


Example:

${Date.ThisYear} will return the current year number i.e. 2018.

Last modified on Jan 23, 2018