no. of day

[amy]

When I type the following statement in the update query,
it doesn't show me the right result if the dates are
between different years e.g. 7/1/2002 & 6/1/2003?

DateDiff("d",[1st of the month date],[Contract Sign Date])

Could you let me know how to fix it?

Thanks,
Amy