Education & Events

___________'_+_vBoCsEvent.Title_+_'_________'_+_(CASE_CAST(vBoCsEvent.BeginDate_AS_VARCHAR(11))_WHEN_CAST(vBoCsEvent.EndDate_AS_VARCHAR(11))_THEN__(CAST(DATENAME(month,vBoCsEvent.BeginDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(day,vBoCsEvent.BeginDate)_AS_VARCHAR(20)))_+_'_@_'_+__(CASE_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_=_12_THEN_('12pm')__WHEN_CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_=_0_THEN_('12am')_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_>_12_THEN_(CAST(CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_-_12_AS_VARCHAR(10))_+_'pm')_ELSE_(CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_VARCHAR(10))_+_'am')_END)_+_'_-_'_+_(CASE_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_=_12_THEN_('12pm')__WHEN_CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_=_0_THEN_('12am')_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_>_12_THEN_(CAST(CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_-_12_AS_VARCHAR(10))_+_'pm')_ELSE_(CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_VARCHAR(10))_+_'am')_END)_ELSE_(CAST(DATENAME(month,vBoCsEvent.BeginDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(day,vBoCsEvent.BeginDate)_AS_VARCHAR(20))_+_'_-_'_+_CAST(DATENAME(month,vBoCsEvent.EndDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(day,vBoCsEvent.EndDate)_AS_VARCHAR(2)))_END)_+_'_____________'" title="Click here to sort" href="javascript:__doPostBack('ctl01$TemplateBody$WebPartManager1$gwpciHomepageevents$ciHomepageevents$ResultsGrid$Grid1$ctl00$ctl02$ctl01$btn_ResultsGrid_2_Sort_'<div_class="eventBlock">__<span_class="category_'_+_vBoCsEvent.MeetingType_+_'"></span>_________<a_href="https://hchanj.imiscloud.com/HCNJ/HCNJ/Event_Display.aspx?EventKey='_+_CAST(vBoCsEvent.EventCode_AS_VARCHAR(500))_+_'"_class="title">'_+_vBoCsEvent.Title_+_'</a>_________<span_class="date">'_+_(CASE_CAST(vBoCsEvent.BeginDate_AS_VARCHAR(11))_WHEN_CAST(vBoCsEvent.EndDate_AS_VARCHAR(11))_THEN__(CAST(DATENAME(month,vBoCsEvent.BeginDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(day,vBoCsEvent.BeginDate)_AS_VARCHAR(20)))_+_'_@_'_+__(CASE_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_=_12_THEN_('12pm')__WHEN_CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_=_0_THEN_('12am')_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_>_12_THEN_(CAST(CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_int)_-_12_AS_VARCHAR(10))_+_'pm')_ELSE_(CAST(DATEPART(hh_,_vBoCsEvent.BeginDate)_AS_VARCHAR(10))_+_'am')_END)_+_'_-_'_+_(CASE_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_=_12_THEN_('12pm')__WHEN_CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_=_0_THEN_('12am')_WHEN_CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_>_12_THEN_(CAST(CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_int)_-_12_AS_VARCHAR(10))_+_'pm')_ELSE_(CAST(DATEPART(hh_,_vBoCsEvent.EndDate)_AS_VARCHAR(10))_+_'am')_END)_ELSE_(CAST(DATENAME(month,vBoCsEvent.BeginDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(day,vBoCsEvent.BeginDate)_AS_VARCHAR(20))_+_'_-_'_+_CAST(DATENAME(month,vBoCsEvent.EndDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(day,vBoCsEvent.EndDate)_AS_VARCHAR(2)))_END)_+_'</span>_____________</div>'','')">'
' + vBoCsEvent.Title + ' ' + (CASE CAST(vBoCsEvent.BeginDate AS VARCHAR(11)) WHEN CAST(vBoCsEvent.EndDate AS VARCHAR(11)) THEN (CAST(DATENAME(month,vBoCsEvent.BeginDate) AS VARCHAR(3)) + ' ' + CAST(DATENAME(day,vBoCsEvent.BeginDate) AS VARCHAR(20))) + ' @ ' + (CASE WHEN CAST(DATEPART(hh , vBoCsEvent.BeginDate) AS int) = 12 THEN ('12pm') WHEN CAST(DATEPART(hh , vBoCsEvent.BeginDate) AS int) = 0 THEN ('12am') WHEN CAST(DATEPART(hh , vBoCsEvent.BeginDate) AS int) > 12 THEN (CAST(CAST(DATEPART(hh , vBoCsEvent.BeginDate) AS int) - 12 AS VARCHAR(10)) + 'pm') ELSE (CAST(DATEPART(hh , vBoCsEvent.BeginDate) AS VARCHAR(10)) + 'am') END) + ' - ' + (CASE WHEN CAST(DATEPART(hh , vBoCsEvent.EndDate) AS int) = 12 THEN ('12pm') WHEN CAST(DATEPART(hh , vBoCsEvent.EndDate) AS int) = 0 THEN ('12am') WHEN CAST(DATEPART(hh , vBoCsEvent.EndDate) AS int) > 12 THEN (CAST(CAST(DATEPART(hh , vBoCsEvent.EndDate) AS int) - 12 AS VARCHAR(10)) + 'pm') ELSE (CAST(DATEPART(hh , vBoCsEvent.EndDate) AS VARCHAR(10)) + 'am') END) ELSE (CAST(DATENAME(month,vBoCsEvent.BeginDate) AS VARCHAR(3)) + ' ' + CAST(DATENAME(day,vBoCsEvent.BeginDate) AS VARCHAR(20)) + ' - ' + CAST(DATENAME(month,vBoCsEvent.EndDate) AS VARCHAR(3)) + ' ' + CAST(DATENAME(day,vBoCsEvent.EndDate) AS VARCHAR(2))) END) + '
'
Hospice Social Workers' Roundtable Dec 17 @ 10am - 12pm

Job Postings

Search for a Job

Emergency Preparedness is Everyone’s Responsibility

Read More 

HCHANJ News

 Home Health: 'The Year That Was'
 Posted 9 December 2019

Issues Beyond PDGM Disrupted the Industry
Read More >

Home Health Providers Increasingly Outsource Tasks
Posted 6 December 2019

Clinicians find it frees time, allowing staff to focus on high-risk patients 
Read More >

Providers Plan 'Zero' Expansion of Therapy Under PDGM
 Posted 4 December 2019

Other specialized care areas expected to grow.
Read More > 

Many NJ Counties Are Healthcare 'Deserts'
Posted 2 December 2019

13 counties fall short; Cumberland, Ocean, Salem and Sussex most affected.
Read More >

CMS Considers New Quality Measures for Home Health, Hospice
Posted on 27 November 2019

Unpaid family caregivers' time far outstrips current spending on home care. 
Read More >

Join the Home Care & Hospice Association of New Jersey Today

Join Today