>I tried to modify ShortDateFormat and ShortTimeFormat
> but a TimeStamp.AsString always returns in the format
> 'dd/mm/yy hh:mm:ss AM/PM'. The AM/PM part is not
> too handy to use for a direct FB value or parameter.
>
> What do I need to set in a generic routinet to get
> a 24hr time and without the AM/PM suffix and without
> having to check very field to see if it is a TimeStamp or not
> and then set the Display format. (TIBODataset) ?

Did you try the DisplayText instead of AsString?

Jason Wharton