Database Anniversary Dates: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 6: | Line 6: | ||
tables=CollectionLocation | tables=CollectionLocation | ||
|fields=_pageName=unit, StartDate=start, EndDate=end, | |fields=_pageName=unit, StartDate=start, EndDate=end, | ||
DATEDIFF(EndDate,StartDate)=nr of days | DATEDIFF(EndDate,StartDate)=nr of days, | ||
CONCAT("agem",EndDate,"m",StartDate,"m")=years | |||
|order by=unit | |order by=unit | ||
|limit=5 | |limit=5 | ||