Date format display problem.... :(

Hi gurus,

I'm having problem with the date format while displaying report. I'm using Crystal Report 8.0 and have a report with field EFFECTIVE_DATE. I'm using a ttx file to display data in the report where this field has been declared as Date. I have set the format for this field as MM,DD,YYYY but, when the report displays in the application in which I'm using it, the field shows as YY,MM,DD. Can anybody suggest me what shall I do to get it back to MM,DD,YYYY. I'm using C# and .NET 2003 IDE for my application.Right-click on the field on the report and select 'Format Field' option.On the 'Date-time' tab, set the format you need.
From the menu, select File->Options->Fields. Click 'Date' button and set the Order option to MDY.

Hope this helps.

Rashmi