Home DADE

Dateformat in sql

edited November 2010 in DADE
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

Comments

This discussion has been closed.