Difference between revisions of "To days"

From SmartWiki
Jump to: navigation, search
 
 
(5 intermediate revisions by 4 users not shown)
Line 12: Line 12:
 
   To_days(now())
 
   To_days(now())
  
This is helpful when using it to find the amount of days it took for an activity.
+
This is helpful in order to find the amount of days it took for an activity.
  
 
Example: Calculate the number of days between startdate and enddate.
 
Example: Calculate the number of days between startdate and enddate.
  
   (To_days([Enddate])-To_days([Startdate]))
+
   (To_days(enddate)-To_days(startdate))
 +
 
 +
[[Category:Reports]][[Category:JavaScript]][[Category:Date Formats]]

Latest revision as of 15:55, 24 July 2013

To_days Functions

This function is an addition to the other date functions such as Hour() and Minute().

The syntax is

 To_days()

Example 1: will return the today as an integer.


 To_days(now())

This is helpful in order to find the amount of days it took for an activity.

Example: Calculate the number of days between startdate and enddate.

 (To_days(enddate)-To_days(startdate))