Re: Inserting into a date field.

Put quotes around the date when inserting it into a table. Since dates are stored as integers beginning with 1 (12/31/1899), the engine thinks you are inserting 07/15/4558. Nick Leporacci Terron Wright <twright@inbrand.com> wrote in article <60tsh3$hdd@cssun.mathcs.emory.edu>... > I am trying to insert data into a date field and I have not been able to > figure out the correct string for inserting 10/01/97. I have tried > 100197 and when I do a select it comes out at July 15, 4558. I can today > and it puts in today date correctly. Does anyone have a solution. >