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
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