Database Anniversary Dates: Difference between revisions

m moved them to "ended"
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Anniversary dates for:
Anniversary dates for:


<!-- this will self-update the age -->
<!-- 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
}}


* {{Location Age | Location =CON MICU }}
== Legacy ==
* {{Location Age | Location =GRA EMIP }}
{{#cargo_query:
* {{Location Age | Location =GRA MICU }}
tables=CollectionLocation
* {{Location Age | Location =GRA N3 }}
|fields=_pageName=unit,
* {{Location Age | Location =GRA N5 }}
StartDate=start,
* {{Location Age | Location =GRA OVER}}
EndDate=end,
* {{Location Age | Location =GRA W3 }}
DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
* {{Location Age | Location =HSC A4 }}
CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
* {{Location Age | Location =HSC B3 }}
|where=EndDate IS NOT NULL
* {{Location Age | Location =HSC CCU }}
|order by=unit
* {{Location Age | Location =HSC D4 }}
|limit=100
* {{Location Age | Location =HSC D5 }}
|default=no results were found
* {{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 =HSC EMIP }}
* {{Location Age | Location =OAK MICU }}
* {{Location Age | Location =STB B5old }}
* {{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 =STB EMIP }}
 
==Ended==
* [[VIC MICU]] - '''18 yrs 3 mths''' - (1999-Jun-01 to 2017-Sep 25)
* [[VIC N3F]]- '''1 year''' - (2005-Jul-01 to 2006-Jun-30)
* [[VIC N4]] - '''3.5 mths''' - (2017-Sep-29 to 2018-Jan-12)
* [[VIC N5]] - '''12 yrs 2 mths''' - (2005-Aug-01 to 2017-Oct-01)
* [[VIC S3]] - '''12 yrs''' - (2005-Oct-01 to 2017-Sep-22)
* [[VIC S4]] - '''12 yrs''' - (2005-Oct-01 to 2017-Oct-01)
* {{Location Age | Location =VIC EMIP }}
* {{Location Age | Location =VIC S5 }}
* [[VIC N5C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-31))
* [[VIC N4C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-31))


== Wiki ==
* the first account on this wiki was set up 2008-03-11


== Related articles ==
{{Related Articles}}


[[Category:Site and Location]]
[[Category:Site and Location]]