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

[chetan.c]

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

[ShaneMuir]

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

[chetan.c]

Oops!!
Thanks Shane.That was the problem.