Differences

This shows you the differences between two versions of the page.

--- syntax:functions [2017/12/23 08:50] – [Date functions] dmitry
+++ syntax:functions [2019/12/08 05:56] – [Number functions] dmitry
@@ Line 3: / Line 3: @@
 ===== Number functions =====
   * [[syntax:functions:abs]]
+  * [[syntax:functions:acos]]
+  * [[syntax:functions:arctan]]
+  * [[syntax:functions:asin]]
+  * [[syntax:functions:atan]]
   * [[syntax:functions:ceiling]]
+  * [[syntax:functions:cos]]
+  * [[syntax:functions:div]]
   * [[syntax:functions:exp]]
   * [[syntax:functions:floor]]
+  * [[syntax:functions:iseven]]
+  * [[syntax:functions:isodd]]
   * [[syntax:functions:log]]
   * [[syntax:functions:max]]
   * [[syntax:functions:min]]
+  * [[syntax:functions:pi]]
   * [[syntax:functions:pow]]
   * [[syntax:functions:random]]
+  * [[syntax:functions:rem]]
   * [[syntax:functions:round]]
   * [[syntax:functions:roundxl]]
@@ Line 16: / Line 26: @@
   * [[syntax:functions:sqrt]]
   * [[syntax:functions:square]]
+  * [[syntax:functions:tan]]
+  * [[syntax:functions:truncate]]
 ===== Text functions =====
+Note that all text functions that return a text value automatically convert their arguments into text.
   * [[syntax:functions:char]]
+  * [[syntax:functions:code]]
   * [[syntax:functions:compact]]
   * [[syntax:functions:contains]]
@@ Line 54: / Line 68: @@
   * [[syntax:functions:trimstart]]
   * [[syntax:functions:upper]]
 ===== Logical functions =====
   * [[syntax:functions:if]]
   * [[syntax:functions:ifempty]]
   * [[syntax:functions:iferror]]
+  * [[syntax:functions:in]]
   * [[syntax:functions:isboolean]]
   * [[syntax:functions:isempty]]
@@ Line 66: / Line 82: @@
   * [[syntax:functions:true]]
   * [[syntax:functions:when]]
-===== Date functions =====
+===== Date/time functions =====
+  * [[syntax:functions:addhours]]
   * [[syntax:functions:addmonths]]
+  * [[syntax:functions:addyears]]
   * [[syntax:functions:age]]
   * [[syntax:functions:agemonths]]
@@ Line 73: / Line 92: @@
   * [[syntax:functions:day]]
   * [[syntax:functions:format]]
+  * [[syntax:functions:fromunixtime]]
+  * [[syntax:functions:isoweeknumber]]
+  * [[syntax:functions:isweekend]]
+  * [[syntax:functions:localtime]]
   * [[syntax:functions:makedate]]
   * [[syntax:functions:month]]
+  * [[syntax:functions:monthend]]
   * [[syntax:functions:monthname]]
   * [[syntax:functions:monthnamelocal]]
+  * [[syntax:functions:monthstart]]
   * [[syntax:functions:now]]
   * [[syntax:functions:today]]
+  * [[syntax:functions:utctime]]
   * [[syntax:functions:weekday]]
+  * [[syntax:functions:weekdayname]]
+  * [[syntax:functions:weekend]]
+  * [[syntax:functions:weekstart]]
+  * [[syntax:functions:workdays]]
   * [[syntax:functions:year]]
+===== File functions =====
+  * [[syntax:functions:combinepath]]
+  * [[syntax:functions:directory]]
+  * [[syntax:functions:filename]]
+  * [[syntax:functions:fileextension]]
+  * [[syntax:functions:ispathrooted]]
+===== Web functions =====
+  * [[syntax:functions:combineurl]]
+  * [[syntax:functions:decode]]
+  * [[syntax:functions:encode]]
+  * [[syntax:functions:hashhex]]
+  * [[syntax:functions:hmachex]]
+  * [[syntax:functions:isjson]]
+  * [[syntax:functions:isxml]]
+  * [[syntax:functions:jsonvalue]]
+  * [[syntax:functions:uridecode]]
+  * [[syntax:functions:uriencode]]
+  * [[syntax:functions:xmlvalue]]
 ===== Special functions =====
@@ Line 86: / Line 136: @@
   * [[syntax:functions:astext]]
   * [[syntax:functions:empty]]
+  * [[syntax:functions:error]]
   * [[syntax:functions:hash]]
-  * [[syntax:functions:in]]
   * [[syntax:functions:match]]
   * [[syntax:functions:pick]]
   * [[syntax:functions:system]]
-  * [[syntax:functions:user]]