Date Templates

Date templates are used to manipulate dates and datetime fields.

Template name	Template format	Return type
current day	current day	integer
current hour	current hour	integer
current millisecond	current millisecond	integer
current minute	current minute	integer
current month	current month	integer
current second	current second	integer
current year	current year	integer
day from	day from <date or datetime>	integer
day of the month from	day of the month from <date or datetime>	integer
day of the week from	day of the week from <date or datetime>	integer
day of the year from	day of the year from <date or datetime>	integer
days between	days between <date or datetime> and <date or datetime>	integer
weekdays between	weekdays between <date or datetime> and <date or datetime>	integer
get local datetime from	get local datetime from <datetime>	datetime value having a local kind
get unspecified datetime from	get unspecified datetime from <datetime>	datetime value having a unspecified kind
get UTC datetime from	get UTC datetime from <datetime>	datetime value having a UTC kind
hours from	hour from < datetime>	integer
h ours between	hours between <datetime> and <datetime>	integer
millisecond from	millisecond from <datetime>	integer
milliseconds between	milliseconds between <datetime> and <datetime>	integer
minute from	minute from < datetime>	integer
minutes between	minutes between <datetime> and <datetime>	integer
month from	month from <date or datetime>	integer
months between	months between <date or datetime> and <date or datetime>	integer
now	now	datetime
number of days in the month from	number of days in the month from <date>	integer
number of days in the year from	number of days in the year from	integer
second from	second from < datetime >	integer
seconds between	seconds between <datetime> and	integer
-	<datetime>	-
today	today	date
tommorrow	tommorrow	date
year from	year from <date>	integer
years between	years between <date> and <date>	integer
yesterday	yesterday	date
is a leap year	<datetime> is a leap year	Boolean
is a local datetime	<datetime> is a local datetime	Boolean
is a week day	<datetime> is a week day	Boolean
is an unspecified datetime	<datetime> is an unspecified datetime	Boolean
is an UTC datetime	<datetime> is an UTC datetime	Boolean
is on a week end	<datetime> is on a week end	Boolean
minus	<datetime> minus <timespan>	-
plus	<datetime> plus <timespan>	-
plus	<date or datetime> plus <integer> weekday s	date or datetime
i s a date	<text> is a date	Boolean
is a datetime	<text> is a datetime	Boolean