Date manipulation

[ujrao]

Urgent <br><br>Date manupulation. I have date in format 'MMDDYYYY' I<br>want to add 365 days. How can it be done. Can i use any<br>date functions. Please let me know.<br><br>Thanks in advance.<br><br>U.J.Rao

 

[Thane]

First, reverse the date format to YYYYMMDD<br>Next, use FUNCTION INTEGER-OF-DATE to convert the date to an integer.<br>Add 365.<br>Use FUNCTION DATE-OF-INTEGER to convert it back to a YYYYMMDD field.<br>Reverse the date format to MMDDYYYY and you are done!

 

[COBOL]

Thank's Thane.<br><br>I had solved the problem the way you explained. I got the<br>correct answer. <br>Thank you once again.