Thanks Albert and Bill.... for the help. Marc
----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, December 17, 2004 12:28 PM Subject: [RBG7-L] - Re: Dates > If all your date inputs are four digit years, this is all academic. Only if your users enter two > digit years is any of this critical. BTW, I see you have the same typing problems as I do: 1/1/30 > would be 2030... > > As to carbs, etc. I remember when the foot shift on mototcycles was on the right side. I refuse to > even move a new bike, because my bike (an Enfield) was "one up, four down" meaning that downshifts > were a lift up on the lever and a fast upshift was done by stamping fast on the shift lever ... > which is now the rear wheel brake ... the first time I forgot to work with the other foot could > prove interesting ... I would learn what colour hospital ceilings are these days. LOL > > > --- Marc <[EMAIL PROTECTED]> wrote: > > > Hi Albert > > > > I do not know why but this gives my brain a vapor lock. I know > > some of you can remember when cars had carbs instead of fuel injection. > > > > Tell me if I am wrong but I think for my system we want to set the > > Date Year say 5 years more than the current year. Like 10. > > That way when we enter 1/1/99 that will be 1999 and 1/1/30 will > > be 2003.... > > > > This reminds me of when the list was talking about 3 value logic. Heck > > I was born in New Orleans and when to High School in Arkansas... > > I just went Duhhh ...Delete. > > > > How said there is no such thing as a stupid question? > > > > Marc > > > > > > > > > > ----- Original Message ----- > > From: "Albert Berry" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Friday, December 17, 2004 10:35 AM > > Subject: [RBG7-L] - Re: Dates > > > > > > > Marc, the date year setting is the first year of a century of dates, > > allowing you to use two digit > > > dates without confusing the system. The settings below will give you the > > years 1905 through 2004, > > > which is not what I think you probably need. > > > > > > Try: > > > > > > SET DATE FORMAT 'MM/DD/YYYY' > > > SET DATE SEQUENCE MMDDYY > > > SET DATE YEAR 80 > > > SET DATE CENTURY 19 > > > > > > That will give you 1980 - 2079 > > > > > > > > > --- Marc <[EMAIL PROTECTED]> wrote: > > > > > > > I have been using the code below for dates but somewhere > > > > I remember seeing some code that allowed the year to float. > > > > > > > > Does anyone remember that or have a better suggestion? > > > > > > > > SET DATE FORMAT 'mm/dd/yyyy' > > > > SET DATE SEQUENCE mmddyy > > > > SET DATE YEAR 5 > > > > SET DATE CENTURY 19 > > > > > > > > Thanks > > > > Marc > > > > > > > > > > > > > > > > > ===== > > > Albert Berry > > > Management Consultant > > > RR2 - 1252 Ponderosa Drive > > > Sparwood BC, V0B 2G2 > > > Canada > > > (250) 425-5806 > > > (250) 425-7259 > > > (708) 575-3952 (fax) > > > [EMAIL PROTECTED] > > > > > > > > > > > > > ===== > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] > >
