Database Anniversary Dates: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-Anniversary dates in 2015 for:
+Anniversary dates for:
-*HSC ICU - '''27 yrs''' '''(Jul 1988)'''
-*GRA ICU - '''17 yrs''' (Sep 1998)
+<!-- this will self-update the age BUT NOT THE UNITS as they are added and removed -->
-*STB ICU - '''16 yrs''' (May 1999)
+== Current ==
-**STB_CICU - '''8 yrs''' (Jan 15.2007)
+{{#cargo_query:
-*CON ICU - '''16 yrs''' (May 1999)
+tables=CollectionLocation
-*OAK ICU - '''16 yrs''' (Jun 1999)
+|fields=_pageName=unit,
-*VIC ICU - '''16 yrs''' (Jun 1999)
+StartDate=start,
-*HSC Med A4 - '''12 yrs''' (Oct 2003)
+DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
-**HSC Med - '''11 yrs''' (Mar-Apr 2004)
+CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
-*Gra Med - '''11 yrs''' (Jan 2004)
+|where=EndDate IS NULL
-*STB Med - '''11 yrs''' (Aug-Dec 2004)
+|order by=unit
-*VIC Med - '''10 yrs''' (Aug-Oct 2005)
+|limit=100
+|default=no results were found
+}}
+== Legacy ==
+{{#cargo_query:
+tables=CollectionLocation
+|fields=_pageName=unit,
+StartDate=start,
+EndDate=end,
+DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
+CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
+|where=EndDate IS NOT NULL
+|order by=unit
+|limit=100
+|default=no results were found
+}}
+== Wiki ==
+* the first account on this wiki was set up 2008-03-11
+== Related articles ==
+{{Related Articles}}
+[[Category:Site and Location]]