Dateformat in sql

rbuser

Hello.

I have a field (Sale.SA_DATE) of type datetime as autosearch in a report
with a operator "between" and values 01.10.2010,01.11.2010. This looks like
this in sql

( Sale.SA_DATE BETWEEN #2010-09-01 00::00::00# AND #2010-10-01 00::00::00# )

and i get an error on this. What is the problem?

I have tried several ways for the values with no success.

Best regards,
Terje

nicocizik

Hi Terje,

Which database are you connecting to? Take a look at the following article
on how DADE handles date values.

http://www.digital-metaphors.com/rbWiki/DADE/Fundamentals/Date_Formatting



Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com