SQLShots: Simple Date Calculation

I work a great deal with SQL Server Reporting Services and in some if
not most of my previous reports I often needed to calculate days.
Usually the amount of days a Work Order has been open, how many days
it's past due and such. With SSRS it is really simple to accomplish
using the DateDiff() function. If you need to calculate age there is a
bit more logic required. See Jacob's post at http://bit.ly/2O2qWW for
further deatils.

Click here to download:
DateCalculation.sql (0 KB)

Posted via email from wetmatter nonsense

0 comments: