SQL or Conditional format query

J

Joel Allen

I am writing an SQL query using the phrase "3 business days ago" and it is
returning a value of 10-3-05. I am expecting 10-13-05 if today is 10-18-05.

This is not working in the conditional formatting area either using "on or
before" then "3 business days ago" or even the "on or after" function.

Please help.

Thanks,
Joel
 
S

Sue Mosher [MVP-Outlook]

Outlook's DASL syntax doesn't support a "3 business days" syntax. It's picking up on the 3 and combining it with the current month.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top