Forum Discussion

ssvr's avatar
ssvr
Helper III
8 years ago

Date Difference excluding weekends

Hello, I have a starting date and an ending date and I need to count only the working days in between. In other words, the date difference (DATEIFF) between the ending and the starting without tak...
Need Help
  • ssvr's avatar
    ssvr
    Helper III
    8 years ago

    Thanks.

     

    But here they suggested create a Date Table for Isweekday flag.

     

    I worked on almost 10 years data so, cant possible to create Date Table with Isweekday flag ??

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi ssvr,

       

      Yes. It is supported to create a calendar table with more than 10 years.

       

      Regards,

      Yuliana Gu

      • ssvr's avatar
        ssvr
        Helper III
        8 years ago

        Hi @Yuliana,

         

        Thanks.

         

        But its difficult to add 10 years canlender and we have to add for future dates also right ?

         

        can you suggest any alternative for this requirement