Thread: ODBC MS Query - comparing dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoeF JoeF is offline
external usenet poster
  
Posts: 4
Default 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 QuoteReply With Quote