RE: Selecting on dates

2001-01-22 Thread bflynn
-Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 20, 2001 11:06 PM To: CF-Talk Subject: Selecting on dates Hi All, The following function works great for displaying a date, but StartVisit isn't found when trying to compare it in a Select statement. I'd

Re: Selecting on dates

2001-01-21 Thread Paige Chandler
Original Message - From: "Jim McAtee" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, January 21, 2001 1:40 AM Subject: Re: Selecting on dates There are three CreateODBC functions, CreateODBCDate(), CreateODBCDateTime(), and CreateODBCTime(). Which one yo

Selecting on dates

2001-01-20 Thread Paige Chandler
Hi All, The following function works great for displaying a date, but StartVisit isn't found when trying to compare it in a Select statement. I'd really appreciate an example of the correct syntax to use. TIA. Regards, Paige Select * From WebSite WHERE StartDate GT

Re: Selecting on dates

2001-01-20 Thread Jim McAtee
Message- From: Paige Chandler [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Saturday, January 20, 2001 9:03 PM Subject: Selecting on dates Hi All, The following function works great for displaying a date, but StartVisit isn't found when trying to compare it in a Select statement. I'd

Re: Selecting on dates

2001-01-20 Thread Paige Chandler
11:13 PM Subject: Re: Selecting on dates It might be safer to use an ODBC formatted date. Depends on the database. Also, I'm not sure what happens to your 'GT' operator (does CF translate it?), but SQL usually uses operators like , =, , =, =, . SELECT * FROM WebSite WHERE StartDate #Creat

Re: Selecting on dates

2001-01-20 Thread Jim McAtee
2000. SELECT * FROM WebSite WHERE StartDate = #CreateODBCDate(StartVisit)# Jim -Original Message- From: Paige Chandler [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Saturday, January 20, 2001 10:04 PM Subject: Re: Selecting on dates Hi Jim, I've used 'GT' in other Select sta

RE: Selecting on dates

2001-01-20 Thread Raymond B.
. -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: January 21, 2001 00:09 To: CF-Talk Subject: Re: Selecting on dates Hi Jim, I've used 'GT' in other Select statements successfully - but I'm not married to it. The problem is that the field in the table is in the Date/Time format