Display current difference between dates

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

Guest

I have a form that shows data from my tables that i wish to show the number
of days that has elapsed against current date dynamically in a text box on
the form, So I have 3 boxes date received date closed (must not be closed
obviously) and the box i wish to show the days in. I have also tried another
box with current date in and tried datediff but nothing appears in the text
box. I am probably not putting the code in correct place.( I tried in default
value the following DateDiff ("d",[Date()],['received date value txtbox']).
Please help a newbie out...thanks
 
You need the Control Source property rather than the Default Value property.
Default Value is applied only when inserting new records.
 
Back
Top