DIFF_DAY( )

Calculates the number of days between two date values.

Syntax

DIFF_DAY(date1, date2)

Arguments

date1

The first date or date expression to use in the calculation.

date2

The second date or date expression to use in the calculation.

Returns

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.

Example

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:

DIFF_DAY([invoiceDate],[paymentDate])

The following example calculates the number of days from an order date to Christmas:

DIFF_DAY([orderDate], "12/25/10")

The following example calculates the number of days from the current date to Christmas. TODAY( ) is a function that returns the current date.

DIFF_DAY(TODAY(), "12/25/10")

Copyright Actuate Corporation 2012