IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Easytrieve - Previous Week's Date Calculation


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
paramita.barman

New User


Joined: 12 Oct 2006
Posts: 18

PostPosted: Mon Mar 12, 2007 3:28 pm
Reply with quote

Hi all,

I have retrieved a date from a table.Now I want the date just 7 days previos to the date I got from the table.Please tell me a way, how I can calculate the date in my easytrieve program.

The date extracted from the table is an alphanumeric field in the format
YYYY-MM-DD.

Please paste a sample code if possible.

Thanks.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Mar 12, 2007 3:38 pm
Reply with quote

One way would be to convert to julian, subtract the 7 checking for less than one, and convert back.
Have you looked in your manual at the DATECONV routine?
%DATECONV date1 format1 date2 format2
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Need help to append a date&tsp at... DFSORT/ICETOOL 9
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
Search our Forums:

Back to Top