I would guess you could use any format that Firebird/Interbase accepts, so
you should have three options: MM/DD/YYYY, DD.MM.YYYY or YYYY-MM-DD (I'm
not completely certain about this last one).

That is, if you've failed when trying the clients data format - I can see
no reason why IB_SQL shouldn't accept date values in the format set for
that particular machine when supplied through a parameter.

Set