Date Templates

  • Updated

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
hours 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> weekdays
date or datetime
is a date <text> is a date Boolean
is a datetime <text> is a datetime Boolean

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.