pulling progress data

I'm trying to pull data from about 30 progress databases using DTS and
scheduling the jobs to run monthly. I'd like to pull data between
specific dates, but for some reason, I can't figure out how to filter
the data on the progress side.

I want to run a query that will pull all data from
prior-month/8/current-year
and
current-month/15/current-year

I'll also have to account for when it's january, make it december of
the year before.

Any ideas?
thanks,
M@.Well, I figured out part of it...

WHERE ("create-date" >
to_char(CONCAT(CONCAT(to_char("MONTH"(add_months("sysdate"(), - 1))),
'/8/'), LTRIM(to_char("YEAR"("sysdate"())),
' '))))

This whole nasty mess would give you 5/8/2006 if you ran it in June of
2006.

Now I have to figure out the other part of this mess is what the hell
happens when it's January :)

M@.

mattcushing@.gmail.com wrote:
> I'm trying to pull data from about 30 progress databases using DTS and
> scheduling the jobs to run monthly. I'd like to pull data between
> specific dates, but for some reason, I can't figure out how to filter
> the data on the progress side.
> I want to run a query that will pull all data from
> prior-month/8/current-year
> and
> current-month/15/current-year
> I'll also have to account for when it's january, make it december of
> the year before.
> Any ideas?
> thanks,
> M@.