Compute difference between the current date is < 45

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

I have two files. First file has the current date mm/dd/yyyy

Second file is going to have random dates for a year in the same fromat .

mm/dd/yyyy
mm/dd/yyyy
so on

I need to select only those records from the second file for which the difference between the current date is < 45.

Skolusu · Posted: Wed Jun 10, 2009 10:43 pm

cvishu,

You don't need a second file. you can directly use DATE1 in sort which gives you the current date in yyyymmdd format. Assuming your input is FB 80 bytes and your date field is in pos 1, the following JCL will give you the desired results. Just put your input date in yyymmdd format at pos 81 using inrec and we will use that to compare it against current date - 45 days

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Skolusu Thanks for ur response...

No i need to have the date in a seperate file, because its not going to be a normal date.. its bussiness date and may differe from the current date..

Skolusu · Posted: Thu Jun 11, 2009 9:35 pm

cvishu,

Sort products do NOT have the capability of getting relative dates from any given date.

If business day meant Mon - Fri, then we can check that subtract days appropriately from it.

For example if you are running on MON-THU we subtract 45 days, if we are running on SAT we subtract 46 days and if are running on Sunday we subtract 47 days. Let me know if you are interested in this procedure and I will show you a way to do it

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Thanks i would like to try this method.. so that on any weekends i shuld still maintain the correct difference

Skolusu · Posted: Thu Jun 11, 2009 10:05 pm

cvishu,

use the following JCL