I need to validate teh date which is coming from input file in as dd/mm/yyyy. I tried reading as date datatype in Sequential format, it is giving the warning like
I tried changing the datatype as Varchar, i could read data but while using Isvalid() could not check the dd/mm/yyyy format .has import error and no default value; data: {3 0 / 0 9 / 2 0 1 1}, at offset: 264
Could somebody suggest how t odo this?