Database Anniversary Dates: Difference between revisions

No edit summary
Line 5: Line 5:
{{#cargo_query:
{{#cargo_query:
tables=CollectionLocation
tables=CollectionLocation
|fields=_pageName=unit, StartDate=start, EndDate=end, CONCAT("{{Location Age | Location =", _pageName, " }}")=fee,
|fields=_pageName=unit, StartDate=start, EndDate=end,
DATEDIFF(EndDate,StartDate)=nr of days
DATEDIFF(EndDate,StartDate)=nr of days
|order by=unit
|order by=unit