Include records based on the date field

tanguduk · New User Joined: 29 Aug 2005 Posts: 14

Hi ,

I wanted to include records based on the date field like, I want the records which are less than '1995-01-01'. How to achieve this . Please suggest.

Regards
kiran

expat · Posted: Tue Sep 30, 2008 3:06 pm

What record format is the input file.
Where in the input file are the date records.
What format are the date records stored in.
What happens to the records omitted from the sort.

gcicchet · Posted: Tue Sep 30, 2008 3:12 pm

Hi,

is file VB or FB ?

what is LRECL ?

is the date field in a set position ?

is the date field in the format of YYYY-MM-DD ?

Some data examples would not go astray.

Gerry

tanguduk · New User Joined: 29 Aug 2005 Posts: 14

Hi,

Its a FB format , and record length is 125, and the postion of the date positon in the file is 56 format is yyyy-mm-dd. I want the records which are less than '1995-01-01' this date

Regards
Kiran

expat · Posted: Tue Sep 30, 2008 3:20 pm

What have you coded and what were the results ?

ksk · Posted: Tue Sep 30, 2008 4:33 pm

Code the following condition.

tanguduk · New User Joined: 29 Aug 2005 Posts: 14

i have got the results thank you