>Hi,
>
>My VFP 9 app has tons of windows and reports. The backend of the app is SQL Server. If I wanted to change all dates (which are currently in the American format) to European format, what do you suggest (the most effective way)? And do I need to change anything in the SQL Server for that too?
>
>TIA
I think all you need to do is to use SET DATE command in VFP to set your desired format.
Assuming reports don't use private data sessions and all your forms are based on some class, that may be all you need.
If you're sending your dates as parameters to SQL Server, you would not need to change anything, I believe.
If it's not broken, fix it until it is.
My Blog