DateDiff not working

[MadCat]

Hi all

I'm having a problem with the datediff() function in Access 2K.

I have the following code in an unbound text box:

=DateDiff("d",Date(),25/7/2003)

I had expected the result to be 24 but instead the text box is showing -37803

Can anyone shed some light on what i may be doing wrong.

Thanks

 

[IMO]

=DateDiff("d",Date(),#25/07/2003#)

IMO

 

[MadCat]

Thanks for your help IMO, that worked

 

[IMO]

You're welcome

IMO