Subject | Re: Query Edit Mask Examples. Dates |
---|---|
Author | russellbelding |
Post date | 2004-05-18T08:25:59Z |
Hi Christopher
Refer to TMaskEdit in the Delphi Help file.
For the EditMask property use
00/00/0000;1,_
That is myQuery.fieldByname('myDate').EditMask :='00/00/0000;1;_';
Then your client can enter 12012004 and it will appear as 12/01/2004
in the edit control.
The system's short date format will override the presentaion of the
date. Eg Dates may be entered 12122004 and then appear as 12-12-04
Regards
Russell
Refer to TMaskEdit in the Delphi Help file.
For the EditMask property use
00/00/0000;1,_
That is myQuery.fieldByname('myDate').EditMask :='00/00/0000;1;_';
Then your client can enter 12012004 and it will appear as 12/01/2004
in the edit control.
The system's short date format will override the presentaion of the
date. Eg Dates may be entered 12122004 and then appear as 12-12-04
Regards
Russell
--- In IBObjects@yahoogroups.com, "Christopher Hart" <cjh@p...> wrote:
> Looking for some write ups on how to properly make use of the Edit
Mask
> in IB_Query.
> Client wants dates to display as mm/dd/yyyy but for speed of entry
wants
> to be able to enter as mmddyyyy with no slashes.
>
>
> ============================================
>
> Christopher Hart
> Profile Technology Group, LLC