Problem with date in Access 2003

[mbertuol]

Access 2003 Help shows the following syntax:

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

Where Interval is
yyyy - year
m - month
d - day


Nevertheless it does not work.

How would you retrieve the number of days between today "Date()" and a given date "DeliveryDate" in an Access 2003 Query?

Many thanks,

Mauro

 

[The_Doc_Man]

can you be more specific as to why you believe this does not work?

bad numbers?

error messages?

something else?

 

[mbertuol]

can you be more specific as to why you believe this does not work?

bad numbers?

error messages?

something else?

I am attaching a DB with an example. I have a table with [DateONE] and [DateTWO] fields. In the query I have tried to use the expression Expr: DateDiff("d", [DateONE], [DateTWO]). It does not work. Access does not allow the expression. Please try and give some feedback.

Many thanks,

Mauro