Thank you to each of you who contributed to solving my issue. Merry Christmas / Happy Holidays.
Tom -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, December 11, 2008 11:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: 0008 instead of 2008 Actually, I think DATE SEQ is what controls how a date will be interpreted. I believe DATE FOR only controls how the date will be displayed. In any case, I prefer to have SET DATE FOR MM/DD/YY Set DATE SEQ MMDDYY For 2008 I use SET DATE CENTURY 19 SET DATE YEAR 18 If I need to display 4 digit years, I control it in the form or report. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ramsour Mike Sent: Thursday, December 11, 2008 10: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
