I have to load flat file data into ods. Flat file has one <b>date</b> field. its format in file is <b>14/06/2006</b>. But system takes as <b>yyyymmdd</b>. so it is not being loaded.
In excel file also when i am trying to change 14/06/2006 to 20060614 format.It is not being changed.
Please help in this matter.