Minus today

[Guest]

I just want to count the number of days since a record was received..
Could anyone please help me plug in todays date.
This is an example of wht I tried, everything except the last -[Date()]
works fine?


Days: IIf([DateREC] Is Null,Null,[DateREC]-[Date()])


Thanks

 

[Guest]

Try

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

Also, the Date() doesn't need to be in square brackets

 

[Guest]

Excellent, thank you...

Try

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

Also, the Date() doesn't need to be in square brackets

--
Good Luck
BS"D

I just want to count the number of days since a record was received..
Could anyone please help me plug in todays date.
This is an example of wht I tried, everything except the last -[Date()]
works fine?


Days: IIf([DateREC] Is Null,Null,[DateREC]-[Date()])


Thanks