Re: Help !! Using Lov for DATE validation

On 3 Jun 1997 12:33:52 -0700, Dan Peacock wrote:

<snip>
>My first question is "Why are you doing this?" It would be easier to use the
>WHEN-VALIDATE-ITEM trigger to validate the date. Also, if you are conserned
>about the millenium issue, I would use the YYYY mask instead.

I'm doing it this way because thats the way the customer wants to work....

And using the format mask dd-mon-yyyy is a bad way to go because if the user enters 01-jan-90, forms will default this to 01-jan-0090, which is incorrect. By using RRRR you will eliminate the 0090 problem...

For now any new systems being developed should use RRRR for the century..

Anybody have anything to contribute to this?

>In article <3393e36d.4094439_at_news.logica.co.uk>, SmithM_at_logica.com says...
>>
>>Hi There.
>>
>>I have a problem relating to the 'LOV for Validation' text item
>>property.
>>
>>We are using the above property to validate an date entered into a non
>>base table (NBT) field with a format mask of DD-MON-RRRR.
>>
>My first question is "Why are you doing this?" It would be easier to use the
>WHEN-VALIDATE-ITEM trigger to validate the date. Also, if you are conserned
>about the millenium issue, I would use the YYYY mask instead.
>
>>Any ideas chaps?
>>
>>
>>Cheers
>>Mark
>
>Dan
Received on Wed Jun 04 1997 - 00:00:00 CEST