Karen, if you change the date format to mm/dd/yyyy and leave the date
sequence as you have it, it should work for you.
Albert
On 10/05/2011 3:40 PM, [email protected] wrote:
Using 7.6, bringing pieces of a 6.5 windows app over.
Table has a column issue_date. There is a rule on the column that the
date cannot be > .#DATE
My date settings are:
date format mm/dd/yy
date sequence mmddyy
threshold year 88
century 19
In 6.5, if they wanted to type in a date of 1/1/1967, they could type
it in the form with the full 4 digits, it would save properly, and
would not violate the rule. If they had typed in 1/1/67 by itself, it
would violate the rule because it would think it was 2067.
In 7.6, if you type in the 4-digit year, the first 2 digits disappear
when you leave the field, so you just see the "67". And apparently
it is evaluated as 2067 and violates the rule. There appears to be no
way to type in 1967 if you have the sequence mmddyy. Is that true??
I really don't want to change the sequence to mmddyyyy because 99% of
the time they will be typing in the year 2011. This application is
very heavy into dates, and this is the first form I'm converting.
It's disheartening to have this problem right off the bat!
I'm hoping someone has a workaround for me? Thanks!
Karen
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
