Hello All,
I'm adding records from a .dat file (saleco.dat) I'm receiving, into a vfp table.
I've got the file structure pretty much set up but am having issues with converting what should be date data to my vfp table.
The saleco.dat file appears to be storing the date data in a character type field (foaldate) with 6 digits (ie; "051290","060425")
I'm assuming that "051290" should convert to {^1990/05/12} and "060425" should convert to {^1925/06/04}.
I added a new field (date type - "datefoal") to the vfp table and tried to do a conversion to replace the new date field with the data in the "foaldate" field but am not having any luck.
"replace all datefoal with ctod(foaldate)" does not work.
Does anyone have any ideas on how this can be accomplished.
TIA,
Jim Harvey