pulling progress data

[mattcushing@gmail.com]

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@

[M@]

Re: pulling progress data

Well, I figured out part of it...

WHERE ("create-date" >
to_char(CONCAT( CONCAT(to_char( "MONTH"(add_mon ths("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@gma il.com wrote:[color=blue]
> 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@[/color]