calculation of date difference

[Anonymous]

Dear all,

Which function I have to use to calculate no. of days of given dates?

Example:

Date1 - date2 = xx days

Pls suggest.

[Anonymous]

interval(date(DATE_CLOSED)- date(DATE_REPORTED),'d') as [No of Days]

[robert_mika]

Interval(Date1-Date2,'d')

Example

=Interval('1/1/2015'-'2/1/2014','d')

Answer: 334

[avinashelite]

use Interval() function, if you want net working days difference then use networkingdays() function.

[mukesh24]

Use Interval() to calculate day difference or convert date into number & simply subtracts 2 dates