How to get the Prvious day's Date

rchatu214 · New User Joined: 10 Dec 2006 Posts: 5 Location: hyderabad

I have requirement like this.
I have one input file in which one of the field is a date which will be blank initially.But after sorting on another filed, this date field should be updated by previous day's date in the output file. Can any one help on this.

Thanks in advance.
rama

Manuneedhi K · Posted: Thu Jul 17, 2008 6:46 pm

You can use this logic to get the prev day's date.
Note: In my test file i had the sample data for the first 20 bytes.

Frank Yaeger · Posted: Thu Jul 17, 2008 9:24 pm

Manu,

Please update your knowledge of DFSORT before answering questions on it. DFSORT has had the ability to compute relative dates since April, 2006.

DATE1-1 will give yesterdays date in 'yyyymmdd' form. Other variations will give relative dates in other forms.

Rama,

For more information on using relative dates with DFSORT, see:

www.ibm.com/systems/support/storage/software/sort/mvs/peug/

Manuneedhi K · Posted: Thu Jul 17, 2008 9:35 pm

Thanks Frank. I initially tried DATE1P-1 and it didn't work. Should have tried with DATE1-1. My bad. I generally don't respond to DFSORT queries but was so tempted with this one. My apologies.

Manuneedhi K · Posted: Thu Jul 17, 2008 9:42 pm

Also Frank i have SYNCSORT 1.2.3.1R installed in my shop which doesn't
support DATE1-1 and hence the confusion. Sorry again.

Frank Yaeger · Posted: Thu Jul 17, 2008 9:43 pm

Manuneedhi K · Posted: Thu Jul 17, 2008 9:50 pm

Frank,

I have clarified that in the second post. We don't have DFSORT here , we run SYNCSORT

Frank Yaeger · Posted: Thu Jul 17, 2008 10:15 pm

Since you use Syncsort, please consider not posting in the DFSORT Forum to avoid confusion.