Hi,

I convert a datetime string into an equivalent datetime value using the
local machines shortdateformat local global settings. I then try and
insert this value into a TDate field in an FB table, but get an:-
ISC ERROR MESSAGE:
conversion error from string "38204" error.

My insert:-

..'Values ( '+''''+InvRec.ReceiptNo+''', '''+InvRec.InvocieNo+''', '+
FloatToStr(aDate)+', '+

FloatToStr(InvRec.RecordAmount)+')';

I use Encode to create aDate. I take it Encode uses the local
settings(datetime) if I do not override them.

The sql which is run against the server.

Insert Into wrkInvoiceHeader ( ReceiptNo, InvoiceNo, ReceiptDate,
RecordAmount) Values ( '2690', '7482', 38204, 2548.2)

What is the FB TDate format equivalent in Delphi?

Thanks,
Dion.