Thanks, Dawn:
DATE format DD/MM/YYYY
DATE sequence DDMMYYYY
Century threshold YEAR is 50
Default CENTURY is 19
Regards,
Alastair.
----- Original Message -----
From: Dawn Hast
To: RBASE-L Mailing List
Sent: Wednesday, January 28, 2009 3:27 PM
Subject: [RBASE-L] - Re: -ERROR- Specified default value is not valid for
column ReleaseDate (2793)
Alastair
Check to see if your DATE FORMAT and DATE SEQUENCE differ. (Is one mm/dd/yyyy
and the other yyyymmdd)?
Dawn Hast
-------------- Original message from "Alastair Burr"
<[email protected]>: --------------
I'm reloading a table and I guess this is a tightening up that I have
missed.
The column is (not surprisingly) a DATE column and the default is :
(.#DATE)
I've tried un-dotted and without brackets but still get the error.
Stranger, I have two other similar columns, Entry_Date & Up_Date, one of
which has the same default but the other is computed rather than defaulted and
uses an Expression with the calculation: (.#DATE). Both these columns follow
the ReleaseDate in the table so I don't know (yet) if either will fail also.
Any thoughts, anybody?
Regards,
Alastair
----------------------------
Alastair Burr
St. Albans, UK.
[email protected]
-----------------------------
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.15/1921 - Release Date: 28/01/2009
06:37
