Re: Using 'Between' sql for Times/Dates

2001-05-16 Thread W Luke
> 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

Re: [Re: [Using 'Between' sql for Times/Dates]]

2001-05-16 Thread W Luke
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

Re: [Re: [Using 'Between' sql for Times/Dates]]

2001-05-16 Thread Alex
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

RE: Using 'Between' sql for Times/Dates

2001-05-16 Thread Nathan Nelson
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

RE: Using 'Between' sql for Times/Dates

2001-05-16 Thread Andrew Tyrone
> -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

RE: Using 'Between' sql for Times/Dates

2001-05-16 Thread Kelly Matthews
-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

Re: [Using 'Between' sql for Times/Dates]

2001-05-16 Thread W Luke
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

Re: [Using 'Between' sql for Times/Dates]

2001-05-16 Thread Alex
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