>>Why would your VFP date fields contain such a data? To me it's more like a SET DATE issue.
>
>Hi Nick:
>
>Thank you for your response. The fields in the table are OK e.g. when I tab into the field in the table, the date fields are displayed as 06/27/02 or 06/27/2002.
>
>What I am describing is the way it is currnelty being displayed on the report. When I tried it on a different machine that had the Regional settings set to American Date format, then the dates in the report are displayed correctly.
Could you just use the SET DATE format for the report date fields and SET DATE AMERICAN before you run the report and reset it after, or it will affect something else?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison