___Upcoming_Event_'_+_vBoEventMain.EventFunctionName_+_'_'_+_(CASE_CAST(vBoEventMain.StartDate_AS_VARCHAR(11))_WHEN_CAST(vBoEventMain.EndDate_AS_VARCHAR(11))_THEN_CAST(DATENAME(day,vBoEventMain.StartDate)_AS_VARCHAR(20))_+_'_'_+_(CAST(DATENAME(month,vBoEventMain.StartDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(year,vBoEventMain.EndDate)_AS_VARCHAR(4)))_ELSE_(CAST(DATENAME(day,vBoEventMain.StartDate)_AS_VARCHAR(20))_+_'_'_+_CAST(DATENAME(month,vBoEventMain.StartDate)_AS_VARCHAR(3))_+_'_-_'_+_CAST(DATENAME(day,vBoEventMain.EndDate)_AS_VARCHAR(2))_+_'_'_+_CAST(DATENAME(month,vBoEventMain.EndDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(year,vBoEventMain.EndDate)_AS_VARCHAR(4)))_END)_+_'_VIEW_EVENT__'" title="Click here to sort" href="javascript:__doPostBack('ctl01$ciSideContent$ContentRecordTemplateArea$NewQueryMenuCommon$ResultsGrid$Grid1$ctl00$ctl02$ctl01$btn_ResultsGrid_2_Sort_'<div_class="eventBlock">_<a_href="https://sleep.org.au/Public/Events/Event_Display.aspx?EventKey='_+_CAST(vBoEventMain.EventKey_AS_VARCHAR(500))_+_'"><img_src="'_+_REPLACE(vBoEventMain.ImageURL,_'~',_'')_+_'"_/></a>_<span_class="content">_<span_class="sub-title">Upcoming_Event</span>_<span_class="title"><a_href="https://sleep.org.au/Public/Events/Event_Display.aspx?EventKey='_+_CAST(vBoEventMain.EventKey_AS_VARCHAR(500))_+_'">'_+_vBoEventMain.EventFunctionName_+_'</a></span>_<span_class="date">'_+_(CASE_CAST(vBoEventMain.StartDate_AS_VARCHAR(11))_WHEN_CAST(vBoEventMain.EndDate_AS_VARCHAR(11))_THEN_CAST(DATENAME(day,vBoEventMain.StartDate)_AS_VARCHAR(20))_+_'_'_+_(CAST(DATENAME(month,vBoEventMain.StartDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(year,vBoEventMain.EndDate)_AS_VARCHAR(4)))_ELSE_(CAST(DATENAME(day,vBoEventMain.StartDate)_AS_VARCHAR(20))_+_'_'_+_CAST(DATENAME(month,vBoEventMain.StartDate)_AS_VARCHAR(3))_+_'_-_'_+_CAST(DATENAME(day,vBoEventMain.EndDate)_AS_VARCHAR(2))_+_'_'_+_CAST(DATENAME(month,vBoEventMain.EndDate)_AS_VARCHAR(3))_+_'_'_+_CAST(DATENAME(year,vBoEventMain.EndDate)_AS_VARCHAR(4)))_END)_+_'</span>_<a_href="https://sleep.org.au/Public/Events/Event_Display.aspx?EventKey='_+_CAST(vBoEventMain.EventKey_AS_VARCHAR(500))_+_'"_class="btn_TextButton">VIEW_EVENT</a>_</span>_</div>'','')">'
Upcoming Event ' + vBoEventMain.EventFunctionName + ' ' + (CASE CAST(vBoEventMain.StartDate AS VARCHAR(11)) WHEN CAST(vBoEventMain.EndDate AS VARCHAR(11)) THEN CAST(DATENAME(day,vBoEventMain.StartDate) AS VARCHAR(20)) + ' ' + (CAST(DATENAME(month,vBoEventMain.StartDate) AS VARCHAR(3)) + ' ' + CAST(DATENAME(year,vBoEventMain.EndDate) AS VARCHAR(4))) ELSE (CAST(DATENAME(day,vBoEventMain.StartDate) AS VARCHAR(20)) + ' ' + CAST(DATENAME(month,vBoEventMain.StartDate) AS VARCHAR(3)) + ' - ' + CAST(DATENAME(day,vBoEventMain.EndDate) AS VARCHAR(2)) + ' ' + CAST(DATENAME(month,vBoEventMain.EndDate) AS VARCHAR(3)) + ' ' + CAST(DATENAME(year,vBoEventMain.EndDate) AS VARCHAR(4))) END) + ' VIEW EVENT
'
Upcoming Event Sleep in women: pregnancy 6 Jul 2020 VIEW EVENT