...
Acos | Returns the angle whose cosine is the specified number. | Acos(1) | 0 |
Asin | Returns the angle whose sine is the specified number. | Asin(0) | 0 |
Atan | Returns the angle whose tangent is the specified number. | Atan(0) | 0 |
Cos | Returns the cosine of the specified angle. | Cos(0) | 1 |
Sin | Returns the sine of the specified angle. | Sin(0) | 0 |
Tan | Returns the tangent of the specified angle. | Tan(0) | 0 |
...
Date and time related Operators
Formula | Description | Usage | Result |
datediff | units · "y" years · "M" months · "d" days · "h" hours · "m" minutes · "s" seconds
dateformat · "ymd" Y-M-D (default) · "mdy" M-D-Y · "dmy" D-M-Y
returnsSignedValue · boolean parameter (true/false) as to whether return the signed value or the positive value
useLocalTime · boolean parameter (true/false) as to whether the parameter Times should be adjusted from UTC to local time of the device | datediff( · includes optional parameters
Example without optional parameters:
datediff([fieldname1], [fieldname2], “h”, true) | the difference in ‘units’ between date1 and date2
the difference in “hours” between fieldname1 and fieldname2 returns as positive or negative value |
Date FormatdateFormat | The date format is used to display date time in desired format. First parameter is the date and or time value that needs to be formatted. Second parameter is used to specify the format in which information is to be presented. Additionally, when the PI does not want to display UTC Time on date or time picker questions, but rather PI current desired time formatan additional parameter can be utilized to control presentation of information.
. | $dateFormat([fieldname],'MM/dd/yyyy', false)$ $dateFormat([fieldname], 'hh:mm tt', false)$ $dateFormat([fieldname], 'h:mm tt', false)$ | Shows the current date Shows the current time not in UTC time in the format below. Example: 09:00 pm Shows the current time not in UTC time in the format below. Example: 9:00 pm |
...