SQL Date format and crystal date range CR.5

[vincer]

If I have a date range parameter that I use in the record selection formula Eg:

MyTable.Date IN {?Date Range}

Crystal generates an sql statement such as

SELECT MyTable.Date
FROM
MyTable MyTable
WHERE
MyTable.Date >= "2002/5/1 00:00:00AM" AND
MyTable.Date < &quot;2002/5/30 00:00:00AM&quot;

This doesn't return anything because it seems incompatible with the SQL DATEFORMAT which should be DMY (british). Is there a way this can be set in crystal.
I know you can type &quot;SET DATEFORMAT YMD&quot; in SQL query analyser but I don't know how to do it in CR8.5

Incidently if I change the last line to
MyTable.Date < &quot;2002/6/1 00:00:00AM&quot;
it seems to work which means I don't know what the default date format is

Thanks

Vince

 

[chelseatech]

I've always thought SQL server use american (M/D/Y) format dates, but it can also be intelligent if you use a alpha month in the form 14-Feb-2003 Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm