Good discussion. Thanks all. Bill, thanks for the date fix info. On your reply:
>>Format: MM/DD/YY >>Sequence: MMDDYYYY > >Dennis, you have them the wrong way around! My app has always stored the date with a 2-digit year for format and sequence. I realize that this has some drawbacks. My users would storm the castle if they ever had to enter a 4-digit year. I would like to go back in my forms and add some range checks or "formats" to prevent the user from accidentally entering an extra digit or other invalid date. I know that when unloading data the Date Seq is set to MMDDYYYY and then (in my case) back to MMDDYY. A data load was probably aborted and I need to always reset it in my app (lightbulb goes on here). I haven't done this in the past since I have customers with other date formats: DD/MM/YY, YY/MM/DD. Dennis **** At 11:40 AM 8/20/02 -0500, you wrote: >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/ > > Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797 ================================================ 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/
