Pull where date is within next 7 days

[iluvwitter]

Trying to write a query to pull all products expiring in the next 7 days. I have an expiredate column and the date is in format (yyyy-dd-mm + timestamp). Need to pull any dates = today or within 7 days. Timestamp is always 00:00:00.00. Please help!

 

[PHV]

SELECT *
FROM yourTable
WHERE expiredate BETWEEN CURRENT_DATE AND CURRENT_DATE + INTERVAL '7' DAY

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886