Subject RE: [ib-support] Date Format in IB
Author Pete Bray
Jackie,

my approach would be to allow IB/FB to store the date in its own particular
way and format the date prior to display in your application when you
retrieve it. If you are using datasources and TFields etc then you can
specify the display format for the TDateField by using a format string to
control the display. If you are retrieving the data yourself via a simple
query then you can use the txt:=FormatDateTime('DDMMYYYY',YourDate) to get
the string you want to display/edit etc.

Kind regards,
Pete

>
> I have a date field in a table and am using a Delphi TMaskEdit field to
> enable date entry in the format 19032002 but what I am finding is that the
> is stored and retrieved from IB as 19/3/2002. Is there a way to
> change this
> so that the dates' day and month are in fact stored and retrieved in '00'
> format?
>
> Thanks for your help.