At 08:34 PM 6/23/2005, John Docherty wrote:
I have tried editing the table with the latest build of 7.1 and now get the error message '00/00/0000' is not a valid date. I have date columns with dates yet to be entered (and hence are showing as nulls) - could this be something to do with the problem ?
John, See what happens when you use the latest updates! Now you need to check the DATE FORMAT/SEQUENCE of your database. Older versions of R:BASE did not care how the data was stored or displayed, but the latest versions will keep you on your toes. No excuses <g> A simple test is to TALLY the datecolumn at the R> prompt. This exercise will tell you the exact data and the rows with invalid dates in date columns. Do this for all columns with dates, one at a time. Use the UPDATE command to fix those invalid dates. That's all there is to it! Good luck! Very Best R:egards, Razzak.
