|
|
Posted by @sh on 09/13/06 12:54
Apologies for your time, I no longer seem able to reproduce the error so
perhaps your suggestion that I had made a mistake in the date format perhaps
is true - but I do appreciate your help!
Have a good week!
Thanks, @sh
"Roy Harvey" <roy_harvey@snet.net> wrote in message
news:eivfg2ldhsdfltpdggkr64boechkn78kal@4ax.com...
>I don't know. An example that fails tells us a lot more than one that
> works. The question is, can you reproduce the failures?
>
> One thought came to mind just now. A mistake in typing in the date
> string resulted in a string that could not be converted to a datetime
> would cause the sort of problem under discussion.
>
> Roy
>
> On Wed, 13 Sep 2006 13:42:17 +0100, "@sh" <spam@spam.com> wrote:
>
>>Hang on......this query now works fine...what has changed or am I being
>>silly?
>>
>>SELECT *
>>FROM sol_session
>>WHERE (DateGiven >= '10/09/2006') AND (DateGiven <= '12/09/2006')
>>ORDER BY dategiven DESC
>>
>>Is it the brackets?
>>
>>Cheers, @sh
Navigation:
[Reply to this message]
|