Progress SQL question

[HarryBrock]

Hi,

This should be easy and am sure am overlooking a progress function.

I have this(part of the query):

where "inv-tb"-"inv-date" = '2011-01-31'

I want to do something like this:

where "inv-tb"-"inv-date" = todaydate - year(or -12 months)

 

[HarryBrock]

I fix the problem:

where "inv-tb"-"inv-date" >= Curdate - 365

 

[jdpjamesp]

I would put "Curdate - 365" into a variable before you do the query as I think that has a slight impact on performance.