Date Format Mask Question on Forms5

From: AH ROBERTS <a3roberts_at_yebo.co.za>
Date: Mon, 13 Dec 1999 18:48:29 -0200
Message-ID: <836910$t8g$1_at_ctb-nnrp1.saix.net>



[Quoted] Hi folks,

I have an date item on a form. Format Mask property is set to DD/MM/YYYY. Maximum length is 10.
[Quoted] If you enter the date 13/10/1999 or 13 10 1999 or 13.10.1999 it changes the [Quoted] date to 13/10/1999.

Is it possible to set the format mask to a value which will allow the user [Quoted] to enter 13101999? The date must then be automatically formatted with the '/' in between. (user request)
[Quoted] The result of above input is 13/01/0099.

I have tried the following DD"/"MM"/"YYYY and DDFM/MMFM/YYYY. Basically it gives the same incorrect output.

I tried to manipulate the date in the 'When Validate Item' trigger , but for [Quoted] the follwing example 13121999, you get the error message 'Day of the month [Quoted] must be between 1 and 12', because it takes 21 as the month value. Is it possible to write code in some trigger which will fire before the [Quoted] error message from the format error is shown?

Any suggestions or help will be appreciated! Thanks,
Adri Received on Mon Dec 13 1999 - 21:48:29 CET

Original text of this message