Feliciad_06
Offline
Last seen: 4 years 2 months ago
Joined: 01/07/2019 - 10:56
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.
Brian
Welcome mkamagate,
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.
@ctod(date+"-2018","MM-DD-YYYY")
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.
Cheers,
Steven
Pages