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@