Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IB (TCS) DATE Function doesn't work?? 2

Status
Not open for further replies.

euskadi

Programmer
Oct 4, 2001
179
US
I'm querying data from TCS (Aspect) workforce management software, and want to get data for the last week... rather than editing the SQL with VBA, I'd rather just use >(DATE - 8) or SYSDATE, or CURRENT_DATE, or something. Every magic "date" incantation I have tried fails. Any thoughts?
 
try

> 'today'-8

Regards S. van Els
SAvanEls@cq-link.sr
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top