Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Peter Larsson How many more Mondays until I retire? RE: How many more Mondays until I retire?
Jesper-244176
SSCertifiable
Points: 7082
More actions
July 19, 2006 at 6:07 am
#650074
No, no, use the formula above:
select datediff(d, '19000101', '20060724')/7 - datediff(d, '19000102', '20060717')/7
returns 2, i.e 2 Mondays between the 17th and the 24th.