Calculating to number of Days between 2 dates!!!!

[Kckronic21]

Hi, I was wondering if there was a way to calculate the total number of days beteen to dates? I whave a field called "Date_of_Hire" and I want to display the number of days between the "Date_of_Hire" field and the current date. I have tried using the DateDiff function, but I was unsuccessful. Any help would be appreciated. Thanks!

 

[lblastick]

Are you using 97 or 2000?

 

[Kckronic21]

I am using MS Access 2000.

 

[MichaelRed]

Shouldn't make any difference. DateDiff == DateDiff

Days: DateDiff("d, Date", [DateHire])

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over