Get days

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sajithamol
    #1

    Get days

    Is there anyway i get the total number of working days between two specified dates in TSQL?
    Tags: None
    • Vidhura
      New Member
      • May 2007
      • 99
      #2
      Originally posted by sajithamol
      Is there anyway i get the total number of working days between two specified dates in TSQL?
      Hope the following helps
      select datediff(d,getd ate(),'12/12/2007')

        Comment

        • shaileshb
          New Member
          • Jun 2007
          • 27
          #3
          u can use the query like

          Select Sum(WorkDays) TotWorkDays From WorkTable
          Where WorkDate Between '01/01/2007' AND '06/30/2007'

            Comment

            Previous template Next
            Working...