Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
offspring22
Starting Member
38 Posts |
 Posted - 2013-04-30 : 13:45:08
|
| Hello,I've been asked to create a report that will display those reaching a 5, 10, 15, etc anniversary in a given time period. For example, those reaching one of the 5 year anniversaries during this quarter (Q2 2013). The fields I have to work with are Join_Date (Date they joined) and Service_ Interruption (number of months interrupted service which needs to be calculated to exclude that time). Any advice on how to go about doing so? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Finding those reaching an anniversary