Hi Gurus,
I am trying to load an ODS which has 0calday field from a flat file. The flat file has the format for the date mm/dd/yyyy. Now not all the rows on the flatfile have this format. Some of them have dates like 2/1/2001 or 2/12/2001 or 12/2/2002. When I am using DATECONV formula in my update rules, I am using the following syntax DATECONV( Shipping Date, 'MDY', '/' ): what happens is only the first 8 characters are displayed and the date is displayed as 2/12/200 or 12/2/200. The other date is just fine.
Could you please help.
Ashmith Roy