I have created a VB.Net app that takes data from Visual Foxpro and inserts it
into SQL Server.
The problem I am running into is that I have come across records in Foxpro
where the dates are as follows:
'08/08/0997 12:00:00 PM'
Obviously, SQL Server does not accept 0997 as a valid date, and the back of
my mind is asking why is Foxpro even allowing this. But anyway, my question
is, what is the best way to validate a Foxpro "date" in VB.Net as I read it
in from VFP and before I insert it into SQL Server?
I have several thoughts but wanted to see what all you experts think.
TIA...
--
Thanks,
Scott