Subject Subtract from date, Now
Author William L. Thomson Jr.
I need to run a query including the last 30 days. I am thinking
something along the lines of

SELECT * FROM TABLE WHERE COLUMN<='NOW'-30;

But I know the above does not work

Any ideas or suggestions


--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios, Inc.
http://www.obsidian-studios.com