DSXchange

Posted: **Wed Aug 29, 2012 6:55 am**

Hi,

Im trying to read a date column in sequential file stage.
The date format string in the extended properties of the column is specified as:

Code: Select all

%(d,s)/%(m,s)/%yyyy

I'm able to read date like 1/1/2012 but with same format I'm unable to read the date like 12/31/2012. The output appears like this *******

I got this from the developer guide:

If you specified the following date format property:
%(d,s)/%(m,s)/%yyyy
Then the following dates would all be valid:
8/ 8/1958
08/08/1958
8/8/1958

Unable to figure out what I'm missing.

Thanks,
Chetan.C

Posted: **Wed Aug 29, 2012 7:48 am**

Look closer at your input and compare it to your required format. Hint: There is no 12th day of the 31st month

Posted: **Wed Aug 29, 2012 11:23 pm**

Oops!!
Thanks Shane.That was the problem.

DSXchange

Date format %(d,s)/%(m,s)/%yyyy in Sequential file

Date format %(d,s)/%(m,s)/%yyyy in Sequential file

Re: Date format %(d,s)/%(m,s)/%yyyy in Sequential file