Write, Bureaucrats, Administrators
4,332
edits
Calculation field: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 73: | Line 73: | ||
=== Date/Time Functions === | === Date/Time Functions === | ||
{| class="wikitable" | {| class="wikitable" style="font-size:120%" | ||
! Function !! Arguments !! Returns | ! Function !! Arguments !! Returns | ||
|- | |- | ||
| datediff || date<br/>date || number of days between the 2 dates | | '''datediff''' || date<br/>date || number of days between the 2 dates | ||
|- | |- | ||
| dateadd<br/>4 arguments || date<br/>days<br/>months<br/>years || date incremented by the time interval | | '''dateadd'''<br/>4 arguments || date<br/>days<br/>months<br/>years || date incremented by the time interval | ||
|- | |- | ||
| dateadd<br/>7 arguments || date<br/>seconds<br/>minutes<br/>hours<br/>days<br/>months<br/>years || date incremented by the time interval | | '''dateadd'''<br/>7 arguments || date<br/>seconds<br/>minutes<br/>hours<br/>days<br/>months<br/>years || date incremented by the time interval | ||
|- | |||
| '''formatDate''' || seconds since start of Jan 1 1970 || equivalent date string | |||
|- | |||
| '''formatDateTime''' || seconds since start of Jan 1 1970 || equivalent date/time string | |||
|- | |||
| '''formatTime''' || seconds since start of Jan 1 1970 || equivalent time string | |||
|} | |} | ||