Adding 7 days

10 pts.
Tags:
SAP
I have created a substring that adds 7 days to the system ship date, the problem is that it continues counting days in the same month, for example: if the system date is June 26th the query will give me June 33rd. can this be corrected?
ASKED: June 4, 2009  7:32 PM
UPDATED: June 15, 2009  8:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

IF your coding in ILE try the ADDDUR opcode

D TodayDate S 10D DATFMT(*ISO)
D NEXTWEEK S 10D DATFMT(*ISO)

Set todays date to this format “YYYY-MM-DD”

The next command will add 7 days and adjust for overflow in the month.

C TodayDate ADDDUR 7:*D NEXTWEEK

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JennyMack
    Hi there, Can you please be more specific? I noticed you didn't list the program you're using. Thanks, Jenny Community Manager
    4,280 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following