Job sequencer problem

chulett · Post by **chulett** » Tue Mar 10, 2015 3:26 pm

ray.wurlod wrote:suggested @DAY usage

kumarjit · Post by **kumarjit** » Tue Mar 10, 2015 11:01 pm

I'm still peeking on the options available to get done with issue.
My bad to keep this post in the WORKAROUND status. Will try your's way(using routine) and the one Ray pointed out( @DAY=@DAY+1).

Till then, its UNRESOLVED to me!!

Will keep you posted.

Regards,
Kumarjit.

kumarjit · Post by **kumarjit** » Tue Mar 10, 2015 11:17 pm

Correct me if I'm wrong Ray.
If today is March 31st, 2015, i.e., the last day of the current month,then:

@DATE=03/31/2015
@DAY=31

Now @DATE+1 will return me 04/01/2015 as its is similar to adding days to a date, but shouldn't the expression @DAY+1 return me 32 instead of 1, as I'm simply adding 1 to the numerical day count?

As @DAY is the numerical day value extracted from @DATE, will @DAY+1 translate in a similar way from @DATE+1 value?

Regards.
Kumarjit.

kumarjit · Post by **kumarjit** » Tue Mar 10, 2015 11:37 pm

qt_ky wrote:Try using the User Variables stage.

Could you please clarify how the User Variable stage caters?

Regards,
Kumarjit.

qt_ky · Post by **qt_ky** » Wed Mar 11, 2015 6:56 am

Doesn't @DATE give the current date in an internal format? You could add 1 to that number, convert the result to a normal looking date format, then check the day part of it, if it's equal to 1...

ray.wurlod · Post by **ray.wurlod** » Wed Mar 11, 2015 2:47 pm

... which is what @DAY is already doing for you!

ray.wurlod · Post by **ray.wurlod** » Wed Mar 11, 2015 2:47 pm

I guess I misled you with @DAY + 1. Ignore that.
Use Oconv(@DATE + 1, "DD") = 1