>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


Hi if you send date as parameter to sql side, there isn't you have to change:

myDate = date()

sqlexecute("select * from mutable where transdate > ?myDate"

VFP converts this date whatever SQL collate and your date format, doesn't matter.