Difference between revisions of "To days"

From SmartWiki
Jump to: navigation, search
 
Line 16: Line 16:
 
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))

Revision as of 08:40, 14 February 2008

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 when using it 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))