Auto update form field to calculate number of days overdue

[wilson52]

I'm trying to update a form field to calculate number of days overdue based on another projected training date field on my form.
This is what I have on my control source line:

=DateDiff("d",[Projected Training Date],Date())

I'm getting Name? in field. Any help appreciated

[Seth Schrock]

Have you checked to make sure that your field name is spelled correctly?

[hvsummer]

you may have problem with datatype, first checking name as seth schrock suggestions. next, check your date's field data type.

you can use datevalue() to force access recognize value as date.

=DateDiff("d",datevalue([Projected Training Date]),Date())