🚀 go-pugleaf

I know that this does not really answer your question, but I usually use the
Format function:

WHERE Format(MyDateTimeField,"MM/DD/YYYY") >
Format("01-01-2004","MM/DD/YYYY)

This lets me keep things as strings which are much easier to deal with (IMO)

HTH,
Ken

"Claudio Andre Heckler" <Claudio.Heckler@flexint.RemoveThis.com> wrote in
message news:4007ee3b$1@newsgroups.borland.com...
> Hi there, this is getting me nuts ...
>
> How do I add date/time literals to a SQL query for Access?
>
> I'm trying to run something like this:
>
>     Select * from MyTable Where
>     MyDateTimeField > #2004-01-01 00:00:00#;
>
> But using # as the data/time delimiters makes CBuilder complain with an
> "Parameter
> object is improperly defined. Inconsistent or incomplete information was
> provided."
> error message.
>
>
> I traced the error to the #s: if I query for something like this:
>
>     Select * from MyTable Where
>     MyNumericField > 100;
>
> I don't get any errors, it all works fine.
>
>
> I don't want to use parameters, I much rather embed my filter in the WHERE
> clause.
>
> So, long story short: how do I embed MS-Access date/time literals in a
> CBuilder SQL
> query ???
>
>
> Many thanks in advance!
>
> Claudio
>
>
>