When I use the query builder to do a date range it generates the following code which fails
select * from Dbtr_Paymnts_General
WHERE (Dbtr_Paymnts_General.Date_Of_Payment BETWEEN '11-23-2011' AND '11-29-2011')
But if I use the code that Crystal reports created it works fine
select * from Dbtr_Paymnts_General
WHERE (Dbtr_Paymnts_General.Date_Of_Payment BETWEEN {d '2011-11-23'} AND {d '2011-11-29'})
Is there a way to get the query builder to create code that will work?
Workaround:
None
Status:
Unfortunately right now the Query Builder does not support custom's format for date and time constants.
