Sorry for any confusion - I haven't used only 2 digits for the year since about 1995 when people at work began to worry about Y2K.
Regards, Alastair. ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 12:50 PM Subject: [RBASE-L] - Re: Unload & pack in 1.866 lost rows > Marc, > > Actually, you have the optimum settings here. The "format" is the usual > output. the "sequence" is the expected input. If you had YYYY in your > sequence, you would be forcing data entry to type all four digits all the time, > otherwise the years would be stored as 0003, 0004, 0005, etc, instead of > 2003, 2004, 2005. > > I'm quite certain this doesn't have anything to do with your problem. > > Bill > > On Fri, 8 Aug 2003 07:58:36 +0100, Alastair Burr wrote: > > >Marc, > > >I don't know if it will cause any problems but your date sequence contains > >only 2 characters for the year and the format contains all 4. > > >As the format tries to display what's in the sequence you may not be > seeing > >everything. > > >The only other thing that might be causing a problem is that your NULL > >statement is near the end and not at the start when begin to define the > >pairs of settings. If you have some weird null to start with - unlikely, but > >not impossible - then you might be getting some odd effect. >
