3 Replies Latest reply: Dec 15, 2016 10:34 PM by Chris Funkhouser RSS

    Using a variable in NetWorkDays function?

    Chris Funkhouser

      I have a .qvw file in which I'm using the NetWorkDays function quite often, with a long list of holiday dates, like this:

      NetWorkDays(HRS_DT,DateEntered,'2016-1-1','2016-1-18','2016-2-15','2016-5-30','2016-7-4','2016-9-5','2016-11-24','2016-11-25','2016-12-26','2017-1-2','2017-1-16','2017-2-20')

       

      Because I'm using the function so many times, I'd prefer to use a Variable in place of the long list of dates, so that when I have to add dates, I only have to do it in one place.  So far I've been unable to do this; it is possible, and if so, how?

       

      Thanks,

      Chris Funkhouser