invalid date format

HI,

I am using a BDC to create an SO and the data is fetched from a table.

If i am entering the date in the format 20071001(yyyyddmm) in the table, i am getting the output as 10.01.0720 where as i should get as 10.01.2007. can anybody suggest a work around for the same

shyam