Sorry, although we do have SQL server it is an Access database that the
Support KB is stored in.
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 13:20
To: CF-Talk
Subject: Re: Querying by a date field.
That's weird, what DB are u using? t
:20
To: CF-Talk
Subject: Re: Querying by a date field.
That's weird, what DB are u using? that's working for me on SQL 7/2000
note that Date_Entered must be the colum name, right?
Anyhow, you can probarbly use this also:
SELECT *
FROM Main_Table
WHERE Date_Enter
Ah !
That might explain it as it is an Access DB (although we do have SQL Server
7).
IS there a way to do this in Access do you know off ?
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 12:27
To: CF-Talk
Subject: RE: Querying by a date field
Convert is a SQL function. I do not think
Access recognizes it.
-Original Message-
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 6:57 AM
To: CF-Talk
Subject: RE: Querying by a date field.
Hello Michael,
Just ran your code and got this message:
Error
That's weird, what DB are u using? that's working for me on SQL 7/2000
note that Date_Entered must be the colum name, right?
Anyhow, you can probarbly use this also:
SELECT *
FROM Main_Table
WHERE Date_Entered BETWEEN getdate(-#ddifer#) and getdate()
That will inser
\supportkb\search_result.cfm
Any ideas ?
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 12:19
To: CF-Talk
Subject: Re: Querying by a date field.
try using this:
SELECT *
FROM Main_Table
WHERE convert(char(10),Date_Entered,10
try using this:
SELECT *
FROM Main_Table
WHERE convert(char(10),Date_Entered,101) BETWEEN
#dateformat(date,"dd/mm/")# and #today#
that will ensure Date_Entered is also in "dd/mm/" format.
works for me... let me know!
Thanks,
Michael Lugassy
IT/WEB Specialist
In
7 matches
Mail list logo
