Date Format checking prior to conversion
Posted: Thu May 27, 2004 4:17 pm
Is there anyway to check the format of a char column having dates for valid date format prior to conversion ?
let me explain within an example. We are getting Date value in various formats (dd-mm-yy, dd-mm-yyyy, yyyymmdd totally about 6 fixed formats ) in a char column. Now the code needs to validate this column for valid date and put this date into date database column if it is valid date. I tried using IsValid. I'm not sure how to use IsValid. No much documentation for this function.
Any help on doing this ?
Thanks
let me explain within an example. We are getting Date value in various formats (dd-mm-yy, dd-mm-yyyy, yyyymmdd totally about 6 fixed formats ) in a char column. Now the code needs to validate this column for valid date and put this date into date database column if it is valid date. I tried using IsValid. I'm not sure how to use IsValid. No much documentation for this function.
Any help on doing this ?
Thanks