Re: Date fix

2001-03-29 Thread Rolf Hopkins
IL PROTECTED]> Sent: Friday, March 30, 2001 4:50 Subject: Date fix > We have an older system that we have to put up with for another year, > their "fix" for y2k was, like several others, to place a number one before > the date "ex 1000329 or 1010329 which is interpreted

Re: Date fix

2001-03-29 Thread Scott Baker
Are you inserting them as strings or as dates? At 02:50 PM 3/29/2001 -0600, gary sanders wrote: > We have an older system that we have to put up with for another > year, their "fix" for y2k was, like several others, to place a number one > before the date "ex 1000329 or 1010329 which is

Date fix

2001-03-29 Thread gary sanders
We have an older system that we have to put up with for another year, their "fix" for y2k was, like several others, to place a number one before the date "ex 1000329 or 1010329 which is interpreted as Mar. 29, 2000 or Mar.29, 2001. Is there a way to delete the "1" at the beginning when