Subject Re: [IBO] TIB_Date
Author Geoff Worboys
> My regional settings on my desktop is dd/mmm/yyyy. Dropped a
> TIB_Date control on my form. Value displays correctly as
> '01-Mar-2000'. Changed the date using the drop-down calendar.
> New date can be saved. However, if I change the date manually
> to '02-Mar-2000', IBO complains with '02-Mar-2000' is not a
> valid date and time.'.
> No edit mask nor display format is set for that field.
> What am I doing wrong?

IBO uses the VCL supplied StrToDate and StrToDateTime functions.
These are not as smart of Interbase date processing. In the online
help you will see...

"must consist of two or three numbers, separated by the character
defined by the DateSeparator global variable. The order for month,
day, and year is determined by the ShortDateFormat global
variable--possible combinations are m/d/y, d/m/y, and y/m/d. "

My preference is to setup the display format in the application to
match one of these styles of input so that the display matches the
editing requirement.

Geoff Worboys
Telesis Computing