Retrieve Records Within date range

spamidighantam · New User Joined: 30 Aug 2006 Posts: 8

I would like to retrieve the records within a particular date range.

I think the control card should look like this:

For example,

the flat file contains date in 52nd position like 2006-11-21. I would like to retrieve records between 2006-10-01 and 2006-11-31.

INCLUDE COND = (52,10,CH,GE,DATE1(-)'2006-10-01', OR,
52,10,CH,LE,DATE1(-)'2006-11-31')

But this is not working.

Sreedhar

subhasis_50 · Moderator Joined: 09 Mar 2005 Posts: 363 Location: Earth

Hi,
Try this

Frank Yaeger · Posted: Tue Nov 28, 2006 9:31 pm

Sreedhar,

Here's a DFSORT job that will do what you asked for. I assumed you wanted to include records between 2006-10-01 and 2006-11-31 inclusive.

spamidighantam · New User Joined: 30 Aug 2006 Posts: 8

Thank you so much ...