Function
Name
Description
DATEADD(startdate, numberunits, unit) Add To Date Returns a new Date/Time that adds the specified number of units to the specified starting date value.  e.g.  DATEADD({{mydatefield}}, 6, ‘MM’)   Unit specifiers are:  YY  – whole years  MM  – whole months  DD  – whole days  HH  – whole hours  MI  – whole minutes  SS  – whole seconds
DATEDIFF(startdate, enddate, unit) Difference Between Dates Calculates the total number of minutes, hours, days, months, or years between two date/times.  e.g.  DATEDIFF({{mydatefield}}, now(), ‘HH’)   Unit specifiers are:  YY  – whole years  MM  – whole months  DD  – whole days  HH  – whole hours  MI  – whole minutes  SS  – whole seconds
YEAR(dateval) Year Returns the year portion of the specified date value.  e.g.  YEAR({{mydatefield}})
MONTH(dateval) Month Returns the month portion of the specified date value.  e.g.  MONTH({{mydatefield}})
DAY(dateval) Day Returns the day portion of the specified date value.  e.g.  DAY({{mydatefield}})    Day
HOUR(dateval) Hour Returns the hours portion of the specified date value.  e.g.  HOUR({{mydatefield}})
MINUTE(dateval) Minute Returns the minutes portion of the specified date value.  e.g.  MINUTE({{mydatefield}})
SECOND(dateval) Second Returns the seconds portion of the specified date value.  e.g.  SECOND({{mydatefield}})
DAYWEEK(dateval) Day of Week Returns the numbered week day for the specified date value. Values are 0 through 6 for Sunday through Saturday  e.g.  DAYWEEK({{mydatefield}})
DAYYEAR(dateval) Day of Year Returns the numbered day of the year for the specified date value. Values returned are between 1 and 366.  e.g.  DAYYEAR({{mydatefield}})
tan(). date(). logarithm(). Contextual Functions. random(). globalval(). Choices Functions. imgurl(). userfirstname(). format-date(). userexternalid(). round(). Date/Time Functions. userlastname(). Functions. ‘.’ (dot). Mathematical Functions. pi(). cosh(). degrees().