MVSFORUMS.com

victor · Beginner Joined: 21 Sep 2005 Posts: 14 Topics: 9

Hi,

I am typing out a cobol cics db2 program which had the the following functinality , an user keys out date(of his wish) in the screen and presses enter key , the control comes to my program now what i have to do is retrieve all the transactions for that particular day (by firing a query on table) and pop up on the screen(i use queues if multiple records or fetched) , now the required functionality is if we press PF1 key previous days trascations to be retrieved and if we press pf2 next days trancations are to retrived , the question of the hour is how to add or subract a day from any day i.e i want the sql query to add/subtract a day to given date the date format we are using in tables mm/dd/yyyy .
_________________
VICTOR

kolusu · Posted: Fri May 12, 2006 1:18 pm Post subject:

victor,

Please SEARCH before posting. check these links.

http://www.mvsforums.com/helpboards/viewtopic.php?t=25&highlight=date

http://www.mvsforums.com/helpboards/viewtopic.php?t=3087&highlight=date

Hope this helps...

Cheers

Kolusu

PS: You will not receive an answer if you fail to follow the rules of this forum.
_________________
Kolusu
www.linkedin.com/in/kolusu