Dennis, FORMAT has nothing to do with whether they have to enter with 2 digits or four digits. Only SEQUENCE affects that. FORMAT controls the normal display of what has already been put into the database. It is reasonable to have a 2-digit FORMAT if, for example, you are tight on space on your forms, or don't want to have to go into a lot of reports and put a display format on each field where you really only want to see 2 character years. But you really need to put code in your application -- after the CONNECT command, that sets sequence to 2 digits, or you will find some really old dates again someday down the road, and your users will never see them.
As long as you can teach users that they can type 2 digits but will usually see 4 digits, it's fine to have FORMAT MM/DD/YYYY and SEQUENCE MMDDYY. Bill On Tue, 20 Aug 2002 16:07:37 -0400, Dennis Fleming wrote: >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. > ================================================ 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/
