big trouble with date calculations......

[NeilBelgium]

I've created several tables with short date as the type, and am trying to run queries that make calculations from these dates.

Have tried using now (), date (), but keep getting syntax and other errors.

How DO you calculate the following:

The difference between two dates, eg 4/1/2002 and 10/1/2002 (the non-american way round!). The answer should be six days, but how can it be achieved?

Also, how filter records that have a date either before today (<?) or after today (>?)

this is causing me no end of trouble,n and all help gratefully accepted!!

thanks, neil

 

[cmmrfrds]

Here are a couple of Access functions you can use.

Debug.Print DateDiff(&quot;y&quot;, #1/4/2002#, #1/10/2002#)
Debug.Print DateAdd(&quot;d&quot;, -1, #2/1/2002#)

Run these then do a Control G and you will see how they work.