Yes there is, it is called the @WorkDay function. You place your date within it and it will return a 0 if the date falls on a weekend or 1 if it falls on a week. So your equation to extraction weekends would be @WorkDay(DATE_FIELD) = 0.
I just adding to this post because I want to underline the fact that there are many ways to get to the same end state using this product. The route the the final answer is normally determined by the way the logical part of your brain is wired. My solution to your problem was using the equation below in the creation of the virtual date field.
Same result just less typing and nesting of functions. Note that my full date field is displayed as dd/mm/yyyy as I am in Canada and my default Windows environment variables are setup to display dates this way. IDEA defaults to the Windows setup to display of dates and numbers, but you can format your dates, numbers, time and characters display by entering the column settings area of the software. A quick way to get there is by simply right clicking on any field name and choosing Column Settings... from the pick list presented to you.
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories