4 Replies Latest reply: Jun 27, 2013 7:44 AM by stuart wannop RSS

    Networkdays calculation and date flags

    stuart wannop

      Hi All

       

      Hope you can help.

       

      I have a list of dates in a table running from 1st Jan 2010 to date. I have created a calendar so some dates will be flagged if they fall within the financial year to date, starting 1st April 2013. So what I'm looking at is a table like this:

       

      DateFYTDFlag
      31/03/20130
      01/04/20131
      02/04/20131
      etc.etc...
      30/06/20131
      01/07/2013

      0

       

      Now what I need to do is is show the earliest and the latest dates in that range - at this point in time that would be 1st April 2013 and 30th June 2013. I would then calculate the networkdays once I have those two dates. I'm ok with the network days part, but how do I get the "min" and "max" dates based on the FYTD flag equalling 1.

       

      I hope that explains what I'm after - thanks in advance for any help.

      Stu