ERROR SQL (DA0003) in refresh data

[system]

when I refresh a query between interval date system return this error :
ERROR SQL (DA0003) in refresh data . [odbc sql driver][sql server] conversion date from char to datetime has generated a value of kind datetime not comprised in interval of valid values 242.
This error doesn’t appear only the first time when I refresh query after BO installation.
I have already check setting in control panel and sql driver , it’s ok (I have comparison value with a system , always XP, in which all is ok)
Can somebody help me.
thanks
HI

marco

---

trustweb (BOB member since 2005-10-25)

[system]

Welcome to B B.
Are you convrting the dates from Char to a datetime in the universe? If yes, then are you sure that this conversion wll always be true for values for this column?

Kashif

---

Kashif Saeed (BOB member since 2004-06-02)

[system]

Have a look here:

120×120 10.4 KB

Hi everybody, When we refresh a report in Infoview with the prompt “date of creation” the date have the format MM/DD/YYYY whereas in the universe it’s dd/mm/yyy. What can we do for having always the dd/mm/yyyy? Nota : OS : english SGDB : SQL Server english Thanks Chris Maitre B (BOB member since 2004-09-02)

Your problem is most likely caused by prm files, although that is more normal for Reporter behaviour.
Try changing your prm files for the input date format parameter.

If this is not helping, check how your ODBC sources are set up. Try changing the setting for SQL server messages to the language you are working with.

If that doesn’t help, please post the query itself and the DB you are working with and the version of BO.

---

KMB (BOB member since 2004-02-11)