Hoping I can exclude a certain date range in a query?

Rehrig76

Hi All,

 

Currently, my script work well, and I use sysdate-180 to specify the date range for my data.  If I wanted to exclude a week where the tool was out of control, for example Aug 21-Aug 28, how would I code that in the script so I don't have to manually hid and exclude and recalculate?  

 

Thanks,

 

-Mike

 

 

txnelson

Take a look at the "In Weeks", "In Days"..etc. functions

sysdate-in Weeks(2)

would return a date 2 weeks prior to sysdate