10 pts.
 Adding 7 days
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?

Software/Hardware used:
ASKED: June 4, 2009  7:32 PM
UPDATED: June 15, 2009  8:05 PM

Answer Wiki:
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
Last Wiki Answer Submitted:  June 15, 2009  8:05 pm  by  ToddN2000   3,910 pts.
All Answer Wiki Contributors:  ToddN2000   3,910 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Hi there,

Can you please be more specific? I noticed you didn’t list the program you’re using.

Thanks,
Jenny
Community Manager

 4,265 pts.