DateDiff Expression in Access 2003-Simple?

[CEF2007]

Running access 2003 and want to have field value (3) produce the result (in days) between field dates 1 and field dates 2.

The expression I've used is:

=DateDiff("d",[field1],[field2])

All I get in field 3 is a zero. I've tried different variations of the above expression such as "d", or no "'s or 's

What am I doing wrong?

 

[Larry8696]

Have you checked to see if [field1] and [field2]
are set up as a date field and if you are using a built in
function to populate either field, this might cause your
problem.