Victor:
I believe that 6.5++ allows formatting only for TEXT fields. If you are
interested, I have quick utility to pop a calendar, select a date and fill
the column value with the selected date from the pop-up calendar.
Place a push button right after the date column, Select LAYOUT from the top
menu and then CHANGE FIELD ORDER and make sure that the push button is right
after the date column.
Right-click on the push button and select properties, select a calendar icon
under Load Image and create and EEP as follows:
-- This EEP will pop-up a calendar from where the user can select a date
CLS
SET VAR v_date = (GETDATE('Select Date'))
SET VAR vout =(CHAR(0)+CHAR(15)+CTXT( .v_date) + CHAR(13))
OUTPUT date.$$$
WRITE .vout
OUTPUT SCREEN
CLEAR VAR v_date,vout
PLAY date.$$$
RETURN
Whatever date is selected, it will be placed on the date column.
I hope this information is of help.
Javier,
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln, Suite #14
Olathe, Kansas 66062-4578
Office (913)829-0888
Fax (913)649-2904
Cell (913)915-3137
================================================
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from all system and destroy all copies.
======================================================
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Victor
Timmons
Sent: Wednesday, December 29, 2004 11:19 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Default value or format mask
I have a date field on a form and would like to use a format mask on it.
So I right click the field and select "field settings" then click the
check box "Default value or format mask" and enter my format mask of
mmddyy and get an error reading. "Value entered does not match field data
type". What am i missing here? Isnt that what a format mask is?
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
