Reading back for 6 months ago in the table

Hi All,

I do have data for Meter reading scheduled date are like this in table TE418

ADATSOLL--- Field name(having TE418 -field having value like this)

.

;;;etc

02/20/2003

03/20/2003

04/17/2003

05/16/2003

06/16/2003

07/15/2003

08/12/2003

09/10/2003

.....

.......

......Etc. From this table field .

From this table i need to findout date 6months ago. Example i know the startdate as 08/12/2003, I need to back 6 months & findout the scheduled date 6 months ago, thati 's 02/20/2003.

How can i do this using select statement? Please give me logic.

Thanks