DateDiff

[mithani]

Dear All,

I have two date text boxes and I want to calculate the days difference between two dates. I have put this code but not working.

=NZ(DateDiff("d",[date],[week_ending_date]))

Can anyone help me please?

mithani

 

[boblarson]

You may find yourself in a bad situation due to the field name, or text box, name "date." You should never use an Access Reserved Key Word as a name of an object or field.

Change the name and then refer to it on the form like:

=DateDiff("d", Me.YourDateField, Me.Week_Ending_Date)

 

[mithani]

Oh thanks bob, so kind of you.

mithani