4 Replies Latest reply: Nov 12, 2012 7:50 AM by Gysbert Wassenaar RSS

    How to select days from today to year end with set?

    Göran Hofstedt

      Hi

      With a set I´d like to select the remaning workdays from today to end of the year to get the number of days left and the use that expression to divide on another expression.. The purpuse is to show how many new customers per day it takes to fullfill the goal (of 250 per year). The 2nd expression gives how many new customers they have signed up to current date.

       

      I have a master calendar with day names of the week so I was thinking that maybe start with selecting monday-friday and then from the date-calendar remove certain fixed dates (holidays). How can that be done?