current date minus 13 months

Sailaja Sankisa · New User Joined: 12 Mar 2010 Posts: 4 Location: hyderabad

Hi,

Refering to Sort to include date check for mmddyy format

I have a FB file of length 300 that has a date in 81:10 in the format mm/dd/yyyy.

I need to extract all records with date greater than current date - 13 months.

I tried doing this by first converting the date to yyyymm format and then used (81,10,CH,LT,DATE2-13).

Can this be done in a single step?

Thanks.

Skolusu · Posted: Fri Mar 12, 2010 10:19 pm

sailaja,

SORT products do not have the capability of subtracting months from the current date. If you are ok validating the year and month then the following DFSORT control cards will give you the desired results

Sailaja Sankisa · New User Joined: 12 Mar 2010 Posts: 4 Location: hyderabad

Hi Kolusu,

Thank you very much for the solution.