On Tue, 20 Aug 2002 10:22:57 -0400, Dennis Fleming wrote: >Format: MM/DD/YY >Sequence: MMDDYYYY
Dennis, you have them the wrong way around! Format is what they appear as, Sequence is what you have to do to input them into the database. You are requiring all for digits on input (sequence), so that a date entered as "02" becomes the year 0002. Fix dates this way: UPDATE table SET datecolumn = (ADDYR(datecolumn, 2000)) WHERE datecolumn <= 12/31/0100 Then fix your database settings: SET DATE FORMAT MM/DD/YYYY SET DATE SEQUENCE MMDDYY SET DATE CENTURY 19 SET DATE YEAR 80 Pick a different year if you want, but don't leave it 00. The Date Year is for 2-digit data entry: If someone types in a two-digit year below this number, one century is added to the DATE CENTURY setting. A number at or above that number gets the DATE CENTURY at the beginning. So, with DATE YEAR 80, 1/1/81 is stored as 1/1/1981, but 1/1/79 is stored as 1/1/2079. Be sure that you not only update the CFG files, but that you also connect to the database (as the owner, if you use GRANT/REVOKE), set the settings, and then disconnect from the database. Bill ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
