Date Difference

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

With Access 2000, I'm trying to use this function in a
report but get an error. Can someone tell me what I'm
doing wrong?
My date field ([Date In])is in the format: "8/6/2003
12:19:36 PM"
In my report I'm using the expression: "=DateDiff("d",Date
(),[Date In])"

Thank you!
 
Make sure the name of the text box is not also the name of any field in the
report's record source.
 
Back
Top