|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 25th, 2004, 07:13 PM
|
|||
|
|||
Subtracting dates in ACCESS
Hello,
I am trying to find out whether or not something is past due in SQL view, using MS Access 2000. I have a table with rentals, which includes the attributes rental_date and due_date. I need to find out from the Time table, which has the attribute Days, which movies were returnd late. I have now: Where (rentals.due_date-rentals.rental_date)>Days I am having trouble because it is comparing two different data types--> (xx-jan-1999) and integer days Sorry this is so long-winded, but I hope someone can understand this and answer. THANKS!!
|
|
#2
February 25th, 2004, 11:38 PM
|
||||
|
||||
|
where datediff("d",rentals.due_date,rentals.rental_date)>Days
or perhaps where datediff("d",rentals.rental_date,rentals.due_date)>Days i think the earlier date has to come first in order to get a positive difference
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Subtracting dates in ACCESS |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
