jmd0252
Programmer
- May 15, 2003
- 667
Happy Holidays boys and girls. Question for today, I want to run a query on an access database, so that I get only records within 30 days of an expiration date. I know you gsmart people have got an answer.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
days to expiration
- Thread starter jmd0252
- Start date
- Status
HitechUser
Programmer
jmd0252,
Just take your "date" and add a number. Access will automatically add the correct number of days.
How is this.
SELECT ExpDate, ExpDate + 1 As NewIssue, ExpDate + 365 As NewExp
FROM YourTable;
I hope this helps..
Good Luck...
Just take your "date" and add a number. Access will automatically add the correct number of days.
How is this.
SELECT ExpDate, ExpDate + 1 As NewIssue, ExpDate + 365 As NewExp
FROM YourTable;
I hope this helps..
Good Luck...
- Status
Similar threads
- Question
- Locked
- Question
