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 All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Sorting date into YYYYMMDD, and creat... DFSORT/ICETOOL 13
No new posts IBM IMU Utility for Easytrieve Code t... IBM Tools 0
No new posts Sort card to know that creation date ... DFSORT/ICETOOL 10
No new posts Help with SORT - I need to validate d... DFSORT/ICETOOL 11
No new posts Overwriting SSN Digits in Easytrieve ... CA Products 0
Search our Forums:


Back to Top