Hi Christian,

> > Well, I guess IBO is creating a text-column. Not a date-one.
> > This makes sense - how would you format a date that says
> > 'not defined'
>
> You are right. When I do COALESCE(Z_Date, NULL), the date
> is displayed correctly.
>
> > If you want to format the date to your particular displayformat,
> > you have to do it yourself.
>
> It's a bit OT here, but do you know a good way to modify IBO's way
> of making up fields? My application is non-visual, so I cannot use
> all the opportunities of the visual components.

Why would you want to change that? Why your use of
COALESCE in this particular case?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com