[DUG] firebird query parameters behaving oddly

[Jeremy North]

If you know a date is a given format you can do date conversion based
from that format to the server format.

This is a common issue.

StrToDate and DateToStr both have an overload that accepts a
TFormatStrings structure. You can define the ShortDateFormat you want
in this structure and pass it to the conversion function.

This is the help link for Delphi 2007.

ms-help://borland.bds5/delphivclwin32/SysUtils_StrToDate@string.html


On 7/10/07, Tracey <tracey at logis.co.nz> wrote:
> Unfortunately, I am stuck here, as my app is a cgi/isapi web app that is
> passing the date value as a string.  Even if I convert '10/11/2006' back to
> a date from there, the conversion results in '11/10/2006'