datediff rounding
- by derekcohen
I have a db table in SQL Server which contains a start date for a project.
On a web status page I want to show how many days/weeks/months the project has run, the units depending on the duration. So under 21 days I'd show days, under 7 weeks I'd show weeks, otherwise show completed months. So I get the days, weeks and months values and can then…