Posted to microsoft.public.excel.programming

JoeF

external usenet poster

Posts: 4

ODBC MS Query - comparing dates

Having trouble with SQL statement

table= loans
field_name=pay_date

I want to say WHERE loans.pay_date < TODAY I tried today(), sysdate,
CurrentDate nothing seems to work. Any help is appreciated.

Joe

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ODBC Query	Laddie	Excel Worksheet Functions	0	April 23rd 10 03:35 PM
ODBC query problem	Arvi Laanemets	Excel Discussion (Misc queries)	3	September 26th 08 02:03 PM
ODBC database query	gneissgirl	Excel Discussion (Misc queries)	0	November 10th 05 06:18 PM
Problem with .Background Query option of ODBC Query	Shilps	Excel Programming	0	April 19th 04 06:41 AM
SQL query to ODBC	gkelle[_5_]	Excel Programming	2	February 12th 04 01:34 PM

All times are GMT +1. The time now is 04:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us