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) + '
'
Annual Conference 2020 Apr 30 - May 1

Job Postings

Search for a Job

Emergency Preparedness is Everyone’s Responsibility

Read More 

HCHANJ News

Private Equity Investment in Hospice Likely to Rise
Posted 17 January 2020

Fragmented industry, acceptance of palliative care spurring investors' interest.
Read More >

Hospices Turn to Machine Learning to Identify Eligible Patients
Posted 15 January 2020

Tracking patient progress can increase use of SIA payments.
Read More > 

Walgreens Still Sees Big Future for Small Senior Care Clinics
Posted 14 January 2020

Sees them as 'fundamental' to community health
Read More >

Home Health Outlook for 2020: Private Equity Takeovers, Rising Costs
Posted 13 January 2020

PDGM may cause gaps in referrals from community-based agencies
Read More >

'Generational Tsunami' Prompting Investor Interest in Home Health, Hospice
Posted on 10 January 2020

We are only in the 'very early innings' of consolidations that are likely to continue for a decade.
Read More >

Join the Home Care & Hospice Association of New Jersey Today

Join Today