Re: forms3 dates<6 digits

From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1995/06/30
Message-ID: <DB07v4.BBM_at_CSUFresno.EDU>#1/1


In article <3t1l50$esk_at_nexus.uiowa.edu> DOUGLAS-KELLEY_at_UIOWA.EDU writes:
>I'm interested if any one has a way to handle entering
>a date into a date field in forms 3.0 with less than 6
>digits. For example for Jan 12,1995 I would like to have
>the user enter 11295 and have it go in as 01-12-95.
>I have a format mask set to MM-DD-YY but if 11295 is
>entered it comes out 11-29-05 and since this is a valid
>date no error occurs.
>
>If there is no way to get the date to go in correctly,
>is there a way to force the user to enter 011295, or
>flash a message if they enter less than 6 digits.
>

Change it to char format, and write an on-validate-field trigger to take the text string and re-format it, and re-display it.

This will probable require a hidden field where the real date is "selected into" and "updated from" by the form.

This one will keep you busy for a while.

Also watch out what happens in January, 2000. Forms defaults the century to the century of the client PC in 2-digit years. Received on Fri Jun 30 1995 - 00:00:00 CEST

Original text of this message