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
Date/Time Functions. acos(). number(). cosh(). Text based Functions. Location Functions. Generate a Unique ID Code. globalval(). cos(). ‘.’ (dot). userfirstname(). pi(). param1(). utctoday(). imgurl(). Create a Formula. utcnow(). Data Conversion. Mathematical Functions. round().