0

I am using this query to count days.

I have tried:

select DATEDIFF(day, @startdate, @enddate)
Dale K
  • 21,987
  • 13
  • 41
  • 69
vishu
  • 21
  • 1
  • 1
  • 8
  • 3
    Possible duplicate of [Count work days between two dates](https://stackoverflow.com/questions/252519/count-work-days-between-two-dates) – LuFFy Jun 02 '17 at 06:45
  • You should have a calendar table. See https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/ - By: Aaron Bertrand – TriV Jun 02 '17 at 08:27

0 Answers0