NeilBelgium
IS-IT--Management
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
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