Do you use the default date format of MM/DD/YY? We don't, and we have had problems since upgrading to 9.1(32). Occasionally, the DATE FORMAT reverts to the default and we get errors. I haven't been able to reproduce the problem at will, so haven't contacted RBTI about it yet, but it is persistent.
We use format DD MMM YYYY with a sequence of DDMMYY, so when the format reverts we get July 1 becoming Jan 7 and the 13th to 31st of any month becoming invalid. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Frank > Taylor > Sent: Thursday, March 15, 2012 8:20 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Date error > > > I have been running into an error when in edit mode of browsing a data > set from a table and I attempt to use the replace all column values on > any column (all different types, text, integer,etc) > > -ERROR- Invalid DATE value (2418) > > Now if I go down through the data and change the value manually for each > row, I do not get this error. Also if I use the update command from the > command prompt with the same where condition, no error. Only when > browsing a table and using the replace all column values does this > appear. Any ideas on why this might be appearing ? > > RB 9.1 Version 9.1.5.20214 > > -- Frank > > Frank Taylor - Information Technology Administrator > F.J. O'Hara & Sons, Inc - Araho Transfer Inc. > Boston, MA - Rockland, ME - Miami, FL > Direct Dial - 617-790-3093 > email: [email protected] >
