Advanced Search bug in SQL query maybe.

Scriptcase 8 Discussion
#1

Im not sure if this is bug or if I am somehow doing something wrong. I have a grid and in the advanced search I select a date to search for and it returns no records. When I turn debug on I see that the Sql its trying to run looks like this:

SIZE=12px: SELECT SalesOrder, TrackingNumber, ShipDate, Carrier, ServiceType, Company from CombinedShipments where ShipDate = ‘aaaa-01-13’ and Carrier = ‘Fedex’ LIMIT 0,32[/SIZE]

So is this a bug and was Scriptcase supposed to put the year I entered where the “aaaa” is?
I have the latest version with latest updates installed.

Thanks!

#2

Has you the correct date format on your field?

#3

No the field is just a VarChar field… but it contains a date. I am unable to change to actually being a date field in MySQL since I can’t control the application that writes the date to it.
What I have attempted is to format the field as a date using a format.
perhaps this is why script case doesn’t know how to use the date I select in the calendar?