Input of dates into a prompt with SQL Server 6.5

building semantic layer
1

Has anyone had a problem with the default date format for inputting dates into SQL*Server?

Listserv Archives (BOB member since 2002-06-25)

2

Has anyone else had problems with the default date format for inputting dates into SQL*Server?

I have my regional settings set to English, with a default short date format of dd/mm/yyyy whenever I input a date in response to a @variable('Enter start date") prompt, I have to use the american format, i.e. mm/dd/yyyyy . If I use the english format I get the error DA0005 :- [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of CHAR to DATETIME resulted in a DATETIME value out of range.242

Changing the ODBC.sbo file appears to make no difference. I have now re-installed Business Objects and the ODBC mdac (ODBC driver 3.70.06.90)

Any help appreciated,

Andrew

Listserv Archives (BOB member since 2002-06-25)