Date

Syntax

Function:
  • DATE(val)
Parameters:
  • val = given value
Outputs:
  • a string in a date format
Description:
  • Convert a value to a date value
Used:
in a Formula BuilderFormula Builder

 

Example
Result
Note
DATE(20) 0.91294525072
DATE(val) -0.62988799427 val = 81
DATE(val) 0.35496653913 val = 547
sqrt(). utctoday(). Logic. number(). utcnow(). format-num(). Contextual Functions. sin(). Date/Time Functions. Mathematical Functions. ‘.’ (dot). asin(). Functions. logarithm(). sinh(). format-date(). Excel Financial Functions. radians(). cosh(). int().