DateDiff - Do You See The Problem??

[dryjeans]

Access chokes on this.....Anyone see the problem??

AgeInDays: DateDiff("d"[now()],[date recvd])

[ADezii]

Access chokes on this.....Anyone see the problem??

AgeInDays: DateDiff("d"[now()],[date recvd])

 
AgeInDays: DateDiff("d",Now(),[date recvd])

[dryjeans]

THANKS, Mr Expert!!!!!!!!! !!!

[ADezii]

THANKS, Mr Expert!!!!!!!!! !!!

You are quite welcome.

[NeoPa]

It's also highly inadvisable to use the Now() function when you really want the Date() function. Now() includes the time element as a fraction, so is not the same as a simple date.