HI,
I am trying to process on dates from a VFP 7 data file that we used to use to compare with the new SQL platform we are currently moving into. My problem is the date field from VFP is coming into Excel as a text field yyyymmdd and I can't seem to reformat it.
Can anyone help me with this?
thanks,
stan
PPRIORITY PDISC PDAYS PNET PURDATE TRANDTE DUEDATE DISDATE DISCOUNT PURAMT PAIDAMT
2 0.000 0 20 20030108 20030108 20030128 0 93.78 93.78
1 0.000 0 30 20030128 20030128 20030227 0 100.00 -
Remember - only dead fish go with the flow.
I am trying to process on dates from a VFP 7 data file that we used to use to compare with the new SQL platform we are currently moving into. My problem is the date field from VFP is coming into Excel as a text field yyyymmdd and I can't seem to reformat it.
Can anyone help me with this?
thanks,
stan
PPRIORITY PDISC PDAYS PNET PURDATE TRANDTE DUEDATE DISDATE DISCOUNT PURAMT PAIDAMT
2 0.000 0 20 20030108 20030108 20030128 0 93.78 93.78
1 0.000 0 30 20030128 20030128 20030227 0 100.00 -
Remember - only dead fish go with the flow.