Database Anniversary Dates: Difference between revisions

TOstryzniuk (talk | contribs)
Created page with "Anniversary dates in 2013 for: *HSC ICU - '''25 yrs''' '''(Jul 1988)''' *GRA ICU - '''15 yrs''' (Sep 1998) *STB ICU - '''14 yrs''' (May 1999), CICU - 6 yrs (Jan 15.07) *CON IC..."
 
 
(39 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Anniversary dates in 2013 for:
Anniversary dates for:
*HSC ICU - '''25 yrs''' '''(Jul 1988)'''
*GRA ICU - '''15 yrs''' (Sep 1998)
*STB ICU - '''14 yrs''' (May 1999), CICU - 6 yrs (Jan 15.07)
*CON ICU - '''14 yrs''' (May 1999)
*OAK ICU - '''14 yrs''' (Jun 1999)
*VIC ICU - '''14 yrs''' (Jun 1999)
*HSC Med A4 - '''10 yrs''' (Oct 2003)
**HSC Med - '''9 yrs''' (Mar-Apr 2004)
*Gra Med - '''9 yrs''' (Jan 2004)
*STB Med - '''9 yrs''' (Aug-Dec 2004)
*VIC Med - '''8 yrs''' (Aug-Oct 2005)


<!-- this will self-update the age BUT NOT THE UNITS as they are added and removed -->
== Current ==
{{#cargo_query:
tables=CollectionLocation
|fields=_pageName=unit,
StartDate=start,
DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
|where=EndDate IS NULL
|order by=unit
|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
}}


{{stub}}
== Wiki ==
* the first account on this wiki was set up 2008-03-11
 
== Related articles ==
{{Related Articles}}
 
[[Category:Site and Location]]