I need expression used to add the number of days between to dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying add the number of days between to dates and it is not working. I
have used the following expression: =DateDiff("d",[DateOpen],[CurrentDate]).

I entered this expression in form design view.

Please help...
 
[DateOpen] and [CurrentDate] are not qualified.
If they are controls on your form:
=DateDiff("d",Me.DateOpen,Me.CurrentDate)
If they are field in a table:
=DateDiff("d",[TableName]![DateOpen],[TableName]![CurrentDate])
 
Back
Top