> I am trying to populate the where clause of an
> TIB_Query with dates which are returned by a
> TDateTimePicker.
>
> The date format in my country is mostly DD.MM.YY
> or DD.MM.YYYY (and the DateTimePicker returns the
> dates in this format).
>
> Unfortunately, IB doesn't accept these date formats
> in my select statement.
> So I wonder how I can convert these dates to the format
> IB will accept.
> There must be a routine which serves this purpose, but
> I can't find it.
>
> Can anyone point me into the right direction?

There are some routines in IBO that will take a TDateTime value and make an
IB compliant string out of it. Look in the IB_Utils unit (or IB_Parse) for
something like getIBDateLiteral().

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com