Re: FORMS45 Format Mask

The only safe format mask we have found is 'fmfxMM/DD/RRRR'. The user must still enter the '/'s, but at least an entry of 1/1/1 will go to 01/01/2001 and 1/1/99 will go to 01/01/1999. Before we started using this, we were getting some dates much nearer the year 0000!

See http://www.tcdb.com, in the Forms Conversion section for other forms upgrade information you (or others) might find useful.

Andrew M. Balshem wrote:
>
> We've recently converted forms from version 3.0 to 4.5 and noticed
> that the format mask (for date fields) mm"/"dd"/"yyyy no longer works
> correctly unless you completely enter all the necessary information.
> What I mean is: in version 3 we could enter the date January 1, 1997
> as 01011997 and the format mask would mask as 01/01/1997 and record in
> the database as 01-JAN-97. In version 4.5 entering the date as above
> the mask appears as 01/11/0097. Anyone else have similiar situation
> and gotten a work around other than entering the dashes (no big deal
> but a bother to our data entry personnel.)

-- 
Dan Townsend, Enterprise Database Architect
East Bay Municipal Utility District
375 Eleventh Street, Oakland, CA 94607-4240
mailto:townsend_at_ebmud.com