Try this

Use functions like MONTH, YEAR and DAY to extract a parts of date and joint
it as you wish. later use CDATE to convert it in a valid date.

Regards.


escribió en el mensaje
ups.com...
Thanks. I was using ISTEXT to identify those "NON Data" already.

But how to convert those being identified not "Valid Date" entries such
as "03/20/2006" to a valid date. I suspect those may have some some
hidden identifer to make them non-date entries. How to remove those
identifer(s)?