Calculation field: Difference between revisions

Calculation field (view source)

Revision as of 08:49, 10 December 2016

73 bytes added , 10 December 2016

m

no edit summary

UnConnoisseur

Write, Bureaucrats, Administrators

4,332

edits

@@ Line 135: / Line 135: @@
 ! Function !! Arguments !! Returns
 |-
-| '''datediff''' || date,<br/>date || number of days between the 2 dates
+| '''datediff''' || ''date1, date2''
+| Number of days between the 2 dates (''date1'' - ''date2'')
 |-
-| '''dateadd'''<br/>4 arguments || date,<br/>interval days,<br/>interval months,<br/>interval years || date incremented by the date interval
+| '''dateadd'''<br/>4 arguments || ''date,<br/>intervalDays,<br/>intervalMonths,<br/>intervalYears''
+| ''date'' incremented by the date interval
 |-
-| '''dateadd'''<br/>7 arguments || date,<br/>interval seconds,<br/>interval minutes,<br/>interval hours,<br/>interval days,<br/>interval months,<br/>interval years || date incremented by the time interval
+| '''dateadd'''<br/>7 arguments || ''date,<br/>intervalSeconds,<br/>intervalMinutes,<br/>intervalHours,<br/>intervalDays,<br/>intervalMonths,<br/>intervalYears''
+| ''date'' incremented by the time interval
 |-
-| '''formatDate''' || seconds since start of Jan 1 1970 || equivalent date string
+| '''formatDate''' || ''seconds''
+| Equivalent date string (seconds since start of Jan 1 1970)
 |-
-| '''formatDateTime''' || seconds since start of Jan 1 1970 || equivalent date/time string
+| '''formatDateTime''' || ''seconds''
+| Equivalent date/time string (seconds since start of Jan 1 1970)
 |-
-| '''formatTime''' || seconds since start of Jan 1 1970 || equivalent time string
+| '''formatTime''' || ''seconds''
+| Equivalent time string (seconds since start of Jan 1 1970)
 |-
-| '''now''' || || The current time in seconds since the start of Jan 1 1970<br/>Uses Universal Time (UTC) regardless of local settings or time zone
+| '''now''' ||
+| The current time in seconds since the start of Jan 1 1970<br/>Uses Universal Time (UTC) regardless of local settings or time zone
 |-
-| '''relativeTimeStr''' || start time || String describing the elapsed time since the given start time
+| '''relativeTimeStr''' || ''startTime''
+| String describing the elapsed time since the given start time
 |-
-| '''formatDuration''' || seconds || duration as a string formatted as MM:SS or H:MM:SS
+| '''formatDuration''' || ''seconds''
+| Duration as a string formatted as MM:SS or H:MM:SS
 |}