Skip to Content
0
Former Member
Nov 07, 2005 at 11:21 PM

Date Conversion Error

59 Views

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