Choose Language Hide Translation Bar
Highlighted
Rehrig76
Level II

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

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

 

 

1 REPLY 1
Highlighted
txnelson
Super User

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

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

sysdate-in Weeks(2)

would return a date 2 weeks prior to sysdate

Jim
Article Labels

    There are no labels assigned to this post.