Hello all.
I'm creating a remote parametrized view connected to a SQL Server 7.0 table.
One of the parameters is DateTime. No matter how I define the table in SQL Server or how I define the view, the view is expecting the date parameter in AMERICAN format (MM/DD/YY).I need that it accepts BRITISH format (DDMMYY). How should I define the table in SQL Server?

TIA