DD MM YYYY Loadling into cube

Dear All,

I am new to BW and need some help regarding loading Date values into the cube.

Sample data in flat file

================

ID , Name, Dy, MM, YYYY

1 xxx , 1 , 07, 2000

I built a cube with the following structure..

ID

Name

Date(0caldate)

I need to load the 3 parts of the date from the flat file into 1 date filed when it enters BW....??

I will reward good points and will highly appreaciate speedy response..

Thanking You.

Rao