> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Derricutt, Mark > Sent: Friday, 19 May 2000 11:48 > To: Multiple recipients of list database > Subject: RE: [DUG-DB]: Dates in SQL/Access > > > > You might need to use # around the date as well as in: > > That worked :-) What on earth is Microsoft thinking with #'s? As far as I can tell, using quotemarks is a BDE specific way of handling dates. Not sure what the standard is. --------------------------------------------------------------------------- New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
- [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Scott Cree
- RE: [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Scott Cree
- Re: [DUG-DB]: Dates in SQL/Access Tony Blomfield
- Re: [DUG-DB]: Dates in SQL/Access BJ Wilson
- RE: [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Patrick Dunford
- RE: [DUG-DB]: Dates in SQL/Access Mark Derricutt
- RE: [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Grant Black
- Re: [DUG-DB]: Dates in SQL/Access Tony Blomfield
- Re: [DUG-DB]: Dates in SQL/Access Mark Derricutt
- Re: [DUG-DB]: Dates in SQL/Access Tony Blomfield
