From: Peter Stone on
No it can't be done in a query and there is no vb function. But Graham Seach
wrote one that does the job:
See "A More Complete DateDiff Function" at

http://www.accessmvp.com/djsteele/Diff2Dates.html

With that module installed, this is the function on the control source of my
text box:

=Diff2Dates("md",Date(),[UpdateNext])

Peter