Write, Bureaucrats, Administrators
4,332
edits
mNo edit summary Tag: Mobile edit |
mNo edit summary Tag: Mobile edit |
||
Line 147: | Line 147: | ||
== Calculations == | == Calculations == | ||
=== Can I use JavaScript for my calculation? === | === Can I use JavaScript for my calculation? === | ||
Yes, use the JavaScript field type. The final value assigned will be the result of the | Yes, use the JavaScript field type. The final value assigned will be the result of the calculation. | ||
=== Can I use calculations for multiple fields? === | === Can I use calculations for multiple fields? === | ||
Line 163: | Line 163: | ||
=== Can I perform calculations with dates & times? === | === Can I perform calculations with dates & times? === | ||
Yes, there are a few | Yes, there are a few formulas that can be used to calculate dates: | ||
* To calculate a date by adding days, months or years to a given date, use: dateadd(#{date1},d,m,y), where #{date1} is the value of a date field and d,m,y are integers. | * To calculate a date by adding days, months or years to a given date, use: dateadd(#{date1},d,m,y), where #{date1} is the value of a date field and d,m,y are integers. |