(I’m sending this again, because the original somehow got split into two posts)
I am writing a script and I need to output results to a file based on a table where the data to select is based on a ‘last’ date and an ‘interval’.
Essentially
Name
Last_date
Interval
Jed 2005-06-02 30
Tom 2005-08-02 30
Select name
From table1
Where last_date < now() – [[interval days]];
The interval days part is what is stumping me I need to say “now() – interval ’30 days’” but I need to use the interval column.
How do I make this work?
Thanks,
Jed
