|
Razzak,
I had already tallied the dates and even added dates for the handful that were null, results (or a portion of them, but the format remains consistent) below:
The forms that are opening with "invalid date format" error messages then open to show the date in just this format:
R>tally adddate from biofile
adddate Number of Occurrences
------------------------------------ ---------------------
01/01/1990 1638
04/12/1993 5
04/28/1993 14
04/30/1993 1
06/03/1993 1
06/07/1993 1
When I type SHOW DATE, this is what I get
R>show date
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 30
Default CENTURY is 19
As I understand it, the date format is the display format, and it appears to be correct based on the tally.
If I bring up the form in browse mode, and attempt to navigate through the records, I get the error on every new record.
To add to the confusion, I tried creating a new form, which only had two date fields (there are only two in this form). That form works correctly and does not generate the error.
So, I tried deleting the dates from the form that was coming up with the error message -- so there are now no dates at all on that form but when it's opened it STILL gives the error message.
Its starting to look like I'll have to do this form over from scratch. AAAARRRRRGGGGHHH.
Paula
-------Original Message-------
Date: 08/01/04 15:22:25
Subject: [RBG7-L] - Re: Thought this Error was solved
At 02:38 PM 8/1/2004 -0400, Paula Stuart wrote:
>Razzak.
>
>Doing as you suggested eliminated the error message I was
>getting, but now I have a new one...
>
>When I enter forms in my own database (doesn't happen in
>the samples) I get a error
>
>ERROR - Invalid Date Value - 2418
>
>None of the dates in the database have been changed, no
>variables are created for dates in these forms, and this
>was working fine before the CFG file was re-created.
>
>This error doesn't occur in the sample database forms
>
>Date is set as MM/DD/YYYY and MMDDYYYY
>
>Century Threshold 30 Default Century 19
>
>Why would this occur?
Paula,
Check for the valid dates in that specific column.
What is the DATE FORMAT, DATE SEQUENCE, DATE YEAR and
DATE CENTURY of your database?
The following are DATE settings in RBG7 sample database:
DATE FORMAT MM/DD/YYYY
DATE SEQUENCE MMDDYY
Century THRESHOLD YEAR 30
Default CENTURY 19
In your case, make sure that your database DATE settings
match the data in DATE column(s).
Among many other SETtings, the DATE settings are specific
to database. So, first you need to CONNect the database
and then type SHOW DATE.
Hint: At the R> prompt, use TALLY datecolumname IN tablename
command to see if those dates are correct.
Hope that helps!
Very Best R:egards,
Razzak.
| 
