To Eliminate records based on Date

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

I have requirement to get records which are greater than a certain date which is in the format of mm/dd/yyyy

For e.g first 10 bytes corresponds to date and next transaction , i want to get the rows have date greater than 01/01/2006

10/01/200599923
09/22/200797861
09/22/200720324

Please let me know

Skolusu · Posted: Fri Sep 25, 2009 5:30 am

thunderstorm,

Try this . I assumed that your input is FB recfm and 80 bytes in length

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

is to possible to use any DATE1 function to do it ?

gcicchet · Posted: Fri Sep 25, 2009 6:00 am

Hi,

what do you mean by

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

I meant we have functions like DATE1, Y2W etc. for manipulations on date formats.

gcicchet · Posted: Fri Sep 25, 2009 6:33 am

Hi,

what's wrong with the manipulation that has been provided ?

Gerry

thunderstorm · New User Joined: 23 Mar 2007 Posts: 35 Location: pune

i just wanted to know if there is a way we can do using DATE1 function.
There is nothing wrong in the original solution..but wanted to know if its possible via functions.

Frank Yaeger · Posted: Sun Sep 27, 2009 6:13 am

Did you bother to look up the DATE1 function. It's for the current date. If you want to compare a date based on the current date, you can use DATEn, DATEn+d or DATEn-d. But you asked how to compare to a specific date so that's the solution you were given. Please read the DFSORT books to find out what specific functions do. You can find all of the DFSORT books at:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080