Date Format Mask Question on Forms5
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