karatelung
Registered User.
- Local time
- Today, 00:42
- Joined
- Apr 5, 2001
- Messages
- 84
using Access 2000
in an SQL statement, i have:
[Enter Date] AS PlacedDate
DateAdd("yyyy",1,[PlacedDate]) AS 1Year
DateTraining
what i want the query to do is to show only the records where DateTraining falls between PlacedDate and 1Year. i've tried:
nevermind. i just figured it out as i was typing this, but i'll post this anyway. it might help someone out having the same problem sometime.
the solution:
in an SQL statement, i have:
[Enter Date] AS PlacedDate
DateAdd("yyyy",1,[PlacedDate]) AS 1Year
DateTraining
what i want the query to do is to show only the records where DateTraining falls between PlacedDate and 1Year. i've tried:
Code:
Where DateTraining Between PlacedDate AND 1Yearnevermind. i just figured it out as i was typing this, but i'll post this anyway. it might help someone out having the same problem sometime.
the solution:
Code:
WHERE DateTraining Between [Enter Date] And DateAdd("yyyy",1,[Enter Date])
