ray.wurlod wrote:suggested @DAY usage
Job sequencer problem
Moderators: chulett, rschirm, roy
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.
Pain is the best teacher, but very few attend his class..
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.
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.
Pain is the best teacher, but very few attend his class..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: