Syncsort extract date before two months of current date

seema_285 · New User Joined: 14 Oct 2010 Posts: 13 Location: pune

Hi,
I want to do some manipulations on date which is in mm/dd/yyyy format in my input file.

I want to extract records which have date before two months of current date.

How to do this using sort.??
I have tried with following sort card but got an user abend.

dick scherrer · Posted: Thu Oct 14, 2010 8:59 pm

Hello and welcome to the forum,

One easy thing to do is write a bit of code to generate the sort control statements.

Arun Raj · Posted: Fri Oct 15, 2010 10:29 am

seema_285,

Welcome to the forums!

Are you just considering the month alone and not the date (dd) part?

Can you provide some sample input and expected output out of it?

seema_285 · New User Joined: 14 Oct 2010 Posts: 13 Location: pune

Hi Arun,

PFB the input output details:

Input: 08/05/2010
08/08/2010
10/05/2010
08/18/2010
09/18/2010
08/19/2010

Processing shud be: (input date {mm/dd/yyyy}) - (current date (10/18/2010){mm/dd/yyyy} >= 30 days OR 2 months

Output: 08/05/2010
08/08/2010
08/18/2010

Alissa Margulies · Posted: Tue Oct 19, 2010 9:36 pm

Hello Seema.

Here is an example of a SyncSort for z/OS job that should help you:

seema_285 · New User Joined: 14 Oct 2010 Posts: 13 Location: pune

Thanks Alissa.

This has worked..

But my question is that Can we do the same with in built date functions in sort like &DATE,&DATE1 or &DATE2 ?

Please let me know if you could help me on this.

Thanking you in anticipation.

Alissa Margulies · Posted: Wed Oct 20, 2010 7:50 pm

Seema,

I don't understand your question. Can you please provide an example?

Thanks,

seema_285 · New User Joined: 14 Oct 2010 Posts: 13 Location: pune

Alissa,

Can we rewrite the same sort card with the help of &date or &date paramenters in SYNCSORT....
e.g.
SORT FIELDS=COPY
OUTFIL OUTREC=(01,10,ZD,LT,&DATE2P(MD4/)-2)
OUTFIL OUTREC=(01,10,ZD,GT,&DATE2P(MD4/)-2)

I tried but did not get the results.

Let me know if you could throw some light on it.

Thanks.

Alissa Margulies · Posted: Thu Oct 21, 2010 9:34 pm

You need to reformat your input date field for the comparison. You can code something like this for 60 days:

seema_285 · New User Joined: 14 Oct 2010 Posts: 13 Location: pune

Thank you so much Alissa...