Sql mdb

From: "limelect" <limelect@xxxxxxxxxxxx>
Date: Tue, 12 Feb 2008 13:27:37 +0200

I have moved from pardox to mdb
On paradox i could split the time and date on 2 fields
Now my record stil hase time and date separetly
I need to make an sql on date and time
1.How can i do it
2. I tried with sql startdate=11/09/2008 no luck dose not filter at all (no
error)
3. I tried with sql startdate='11/09/2008' error
4. I tried with sql startdate="11/09/2008" error
5 I tried with sql startdate=11/09/2008 0:0 error
P.S the filed hase only date no time .should i include time,I cannot!!

.

Follow-Ups:
- Re: Sql mdb
  - From: MikeR
- Re: Sql mdb
  - From: yannis

Prev by Date: Ado mdb network
Next by Date: Compare databases
Previous by thread: Ado mdb network
Next by thread: Re: Sql mdb
Index(es):
- Date
- Thread

Relevant Pages

Re: Sql mdb
... On paradox i could split the time and date on 2 fields ... Now my record stil hase time and date separetly ... I need to make an sql on date and time ... The date and time delimiter in an mdb database is # and the date must be mm-dd-yyyy and time is hh:mm:ss if the field in the database is a datetime. ...
(borland.public.delphi.database.ado)
Re: Sql mdb
... As for date is the date field a string?? ... Do you know of a function to convert date/time to mdb format? ... Now my record stil hase time and date separetly ... I need to make an sql on date and time ...
(borland.public.delphi.database.ado)