Tom, FORMAT is the way you want people to see the date, the "output" format. SEQUENCE is the way you want people to be able to enter the date, the "input" format. IF SEQUENCE is four y's, then every single date must be entered with four-digit years. IF SEQUENCE is 2 y's, then dates entered with 2 digits will be set up according to your CENTURY and YEAR settings.
The YEAR setting is relevant if your SEQUENCE is two Ys. For any 2-digit year, put it in the century indicated by the CENTURY setting, but if the 2-digit year is less than the YEAR setting, add another century. So with: DATE FORMAT mm/dd/yyyy DATE SEQUENCE mmddyy DATE CENTURY 19 DATE YEAR 50 1/25/51 becomes 01/25/1951 12/31/49 becomes 12/31/2049 If you want a date before 1950 or after 2049, you merely have to enter the four-digit year. So fix your dates, as Karen and others have suggested. Set your date settings as shown above. Keep your 4-digit FORMAT, but use a 2-digit SEQUENCE. Bill On Thu, Dec 11, 2008 at 2:31 PM, Thomas Eldred <[email protected]>wrote: > The problematic date (contribdate) is inserted by way of a form which is > entered by the user. We use the four digit year format here. Issue arises > when the user enters 12/12/08, but not if 12/12/2008 is entered. > > Startup.rmd includes the commands > > SET DATE CENTURY 19 > SET DATE YEAR 50 > > But in the same exact file as the problem date, two other dates are > inserted > correctly. Their insert codes are: > > INSERT INTO rushtrans (rushnum, pinnumber, processdate) VALUES (.vrushnum, > + > .voldpin, .#DATE) > and > UPDATE rushtrans SET pinnumber = .vnewpin + > WHERE rushnum =.vrushnum AND processdate = .#DATE > > Thank you > > Tom > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Ramsour > Mike > Sent: Thursday, December 11, 2008 11:30 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: 0008 instead of 2008 > > Tom: > > How does the data get into your tables? > > I load a lot of my data from ASCII fixed field files with various date > columns. Some of the values come in as 12/11/2008 while others come in as > 12/11/08 for example. > > If your date format is set to MMDDYYYY and a value comes in to a table as > MMDDYY then that value will show up as 12/11/0008. > > The bottom line is if you are importing data from external files then make > sure your date format setting matches the format of the date values being > loaded. > > Hope that helps. > > Have a great day. > > Mike Ramsour > > -----Original Message----- > From: Thomas Eldred [mailto:[email protected]] > Sent: Thursday, December 11, 2008 11:21 AM > To: [email protected] > Subject: [RBASE-L] - RE: 0008 instead of 2008 > > I must be missing something then . . . my startup file (start.rmd) has > similar language in it...but the entries register incorrectly still. > > Tom > > >
