Type mismatch in expression datediff

[CharlesWhiteman]

I'm using the following in a query but I keep getting Type Mismatch In Expression Error.

Regdate is a Date/Time Field in my Db.

Expr1: DateDiff("d",Date(),[RegDate])

 

[vbaInet]

What about:

Expr1: DateDiff("d",Date(),CDate([RegDate]))

 

[CharlesWhiteman]

Thanks however I am a clot! The error was because of another field unrelated and an incorrect relationship between them in the query. It works as it was having solved that problem!

 

[vbaInet]

Goodie!!!

 

[boblarson]

Just a reminder that for the DateDiff, the EARLIEST date comes first. So, if RegDate is earlier than today it shouild be in the first slot, or else you will get negative numbers.