Flat File Extraction date problems.

Hi All,

I am uploading competitor sales data from flat file.

I am facing some problems in date format.

Can any one suggest what are all the precautions we need take during load like date conversion routines, date format change. or any other.

Thanks in Advance.

Regards

Ravi Chelikani.