0

I am using this query to count days.

I have tried:

select DATEDIFF(day, @startdate, @enddate)
Dale K
  • 25,246
  • 15
  • 42
  • 71
vishu
  • 43
  • 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