Database Anniversary Dates: Difference between revisions

TOstryzniuk (talk | contribs)
m m
 
(30 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Anniversary dates in 2016 for:
Anniversary dates for:
*HSC ICU - '''28 yrs''' '''(Jul 1988)'''
*GRA ICU - '''18 yrs''' (Sep 1998)
*STB ICU - '''17 yrs''' (May 1999)
**STB_CICU - '''9 yrs''' (Jan 15.2007)
*CON ICU - '''17 yrs''' (May 1999)
*OAK ICU - '''17 yrs''' (Jun 1999)
*VIC ICU - '''17 yrs''' (Jun 1999)
*HSC Med A4 - '''13 yrs''' (Oct 2003)
**HSC Med - '''12 yrs''' (Mar-Apr 2004)
*Gra Med - '''12 yrs''' (Jan 2004)
*STB Med - '''12 yrs''' (Aug-Dec 2004)
*VIC Med - '''11 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
}}


<!-- this will self-update the age but the list is slightly different... Trish, keep which one you prefer.-->
== 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
}}


* {{Location Age | Location =CON MICU }}
== Wiki ==
* {{Location Age | Location =GRA EMIP }}
* the first account on this wiki was set up 2008-03-11
* {{Location Age | Location =GRA MICU }}
 
* {{Location Age | Location =GRA N3 }}
== Related articles ==
* {{Location Age | Location =GRA N5 }}
{{Related Articles}}
* {{Location Age | Location =GRA OVER }}
 
* {{Location Age | Location =GRA W3 }}
[[Category:Site and Location]]
* {{Location Age | Location =HSC A4 }}
* {{Location Age | Location =HSC B3 }}
* {{Location Age | Location =HSC CCU }}
* {{Location Age | Location =HSC D4 }}
* {{Location Age | Location =HSC D5 }}
* {{Location Age | Location =HSC H4 }}
* {{Location Age | Location =HSC H4H }}
* {{Location Age | Location =HSC IICU }}
* {{Location Age | Location =HSC MICU }}
* {{Location Age | Location =HSC SICU }}
* {{Location Age | Location =OAK MICU }}
* {{Location Age | Location =STB 5B }}
* {{Location Age | Location =STB B4 }}
* {{Location Age | Location =STB B5 }}
* {{Location Age | Location =STB CCU }}
* {{Location Age | Location =STB CICU }}
* {{Location Age | Location =STB E5 }}
* {{Location Age | Location =STB E6 }}
* {{Location Age | Location =STB MICU }}
* {{Location Age | Location =STB SICU }}
* {{Location Age | Location =VIC EMIP }}
* {{Location Age | Location =VIC MICU }}
* {{Location Age | Location =VIC N3F }}
* {{Location Age | Location =VIC N4 }}
* {{Location Age | Location =VIC N5 }}
* {{Location Age | Location =VIC S3 }}
* {{Location Age | Location =VIC S4 }}
* {{Location Age | Location =VIC S5 }}