View previous topic :: View next topic
|
Author |
Message |
paramita.barman
New User
Joined: 12 Oct 2006 Posts: 18
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
|