Help with SQL date calculations
Posted on 2006-03-30
I am using the shazam report wizard to generate a report to give me a list of chemicals that are expired.
Here is what I have so far.
FROM ":cisdata:MAIN.DB" MAIN,
WHERE ((MAIN.ID = BATCH.ID)
AND (BATCH.SizeTypeID = SIZETYPE.SizeTypeID)
AND (BATCH.LocationID = LOCATES.LocationID))
AND (((BATCH.Expiration < "03/30/2006")))
ORDER BY MAIN.NameRaw ASC,
The date "03/30/2006" is actually shown in the defined search as <TODAY. I guess it just gives the "calculated value" when I actually look at the SQL code.
How could I modify the code to give me anything that expires within 30 days? I tried <TODAY + 30 but that returns and error.