> You're using CreateODBCTime() where you should be using
CreateODBCDateTime():
>
>
>
>
> Your current code will only return the time part for comparison, not the
actualy date associated with the time.
Brill - cheers Andy.
Will
~~
Structure yo
Yes - "General Date."
Any other ideas?
- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 16, 2001 10:44 PM
Subject: Re: [Re: [Using 'Between' sql for Times/Dates]]
> is logdate a d
ell.lists.cftalk
Sent: Wednesday, May 16, 2001 6:52 PM
Subject: Re: [Using 'Between' sql for Times/Dates]
> try...
> where logdate > (now() - 2hours)
>
> "W Luke" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a list of dates and times, in a field ca
s.com/cfdcalendar/
Online Personal Assistant
-Original Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:55 PM
To: CF-Talk
Subject: RE: Using 'Between' sql for Times/Dates
> -Original Message-
> From: W Luke [mailto:[EMA
> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 1:34 PM
> To: CF-Talk
> Subject: Using 'Between' sql for Times/Dates
>
>
> Hi,
>
> I have a list of dates and times, in a field called logDate, which are
> constantly updated. I need to pull
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:34 PM
To: CF-Talk
Subject: Using 'Between' sql for Times/Dates
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2 hours wor
That just pulled all the record, irrespective of time...I get the logic, but
not why it isn't working.
Hmmm.
- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 16, 2001 6:52 PM
Subject: Re: [Using 'Be
try...
where logdate > (now() - 2hours)
"W Luke" <[EMAIL PROTECTED]> wrote:
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2 hours worth of rows that have
been added. I think there's a specific part of time-handling that I
8 matches
Mail list logo