>I'm using DB2 universal db for NT to test but the live system will be in a RISC box.
>If I understand you correctly, I should define the date fields in db2 as text.
Does that mean I have to define them that way in vfp?

the other way around in UDB have it as date type also in views the curresponding fields can be dates - the problem is in query parameters where you have to translate the VFP dates to characters

Arnon