Calculate the difference between 2 dates

[araza123]

Hi all,

I am trying to simply find the difference between 2 dates in my querey. I want the result to be listed in days

i presently have it as
Difference: DateDiff('d',[Claim Entered Date]-[Sale Date Ky],Date())

but this is not yielding the correct results. Anyone know what I am doing wrong here? Thanks in advance

 

[theDBguy]

To get the difference between two dates, you can use either:

Date1 - Date2

or

DateDiff("d", Date1, Date2)

 

[Gasman]

DateDiff calculates between two dates.
You are making one of them a stupid number by subtracting one from another.