The number of days between date1 and date2. If date1 is earlier than date2, the result is a positive number; otherwise the result is a negative number.The following example calculates the time it takes to pay invoices by computing the number of days between each value in the invoiceDate field and each value in the paymentDate field:The following example calculates the number of days from the current date to Christmas. TODAY( ) is a function that returns the current date.


Copyright Actuate Corporation 2012 