MVSFORUMS.com

THRIVIKRAM · Beginner Joined: 03 Oct 2005 Posts: 70 Topics: 34

Hello,

I have the following requirement.

I have a table X which will be updated by jobs that run daily.The rows updated on a particular day can be known from
LST_UPDT_DT colum of the X table.
Now, I have other monthly job which runs last saturday. This job retrieves all the rows that were updated since previous
run(last Saturday of previous month) to current month run(last saturday of this month).
The condition used is X.LST_UPDT_DT > '04/29/2006'.(for example)
But,every time we are hardcoding the Saturday date of previous month.

Is there any way by which we can overcome this burden. I mean,the condition must be such that
X.LST_UPDT_DT > [some quantity] , where [some quantity] should reflect the last saturday of previous month.

Thanks,
Thrivirkam.

kolusu · Posted: Tue May 30, 2006 5:26 am Post subject:

THRIVIKRAM,

THRIVIKRAM · Beginner Joined: 03 Oct 2005 Posts: 70 Topics: 34

Thanks Kolusu,

But Could you please tell how this code is working.
I need this because, when I try giving the date manually(just for testing in the QMF) instead of Current date its throwing the error
"Argument '2' of scalar function '-' is invalid."

Thnx for your time.

acevedo · Posted: Wed May 31, 2006 1:23 am Post subject:

then try

shekar123 · Posted: Wed May 31, 2006 1:42 am Post subject:

acevedo,

You have clearly given the query to know the current date as well the desired result

THRIVIKRAM · Beginner Joined: 03 Oct 2005 Posts: 70 Topics: 34

Yes,Its working!!!

Actually I overlooked that point.

Thanks.