Events
____________________________________________________________________________________________________________'_+_(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)_+_'_______________________________________________________'_+_CAST(DATENAME(hour,vBoEventMain.StartDate)_AS_____________________VARCHAR(20))_+_'_:_'_+_CASE_WHEN_____________________DATENAME(minute,vBoEventMain.StartDate)_<10_then_(_'0'+_____________________CAST(DATENAME(minute,vBoEventMain.StartDate)_AS_VARCHAR(20))_____________________)_else_CAST(DATENAME(minute,vBoEventMain.StartDate)_AS_____________________VARCHAR(20))_END_+_'____________________________________________________________'_+_CASE_WHEN_LEN(vBoEventMain.EventFunctionName)_>_100_then_________________(CAST(vBoEventMain.EventFunctionName_AS_VARCHAR(100))_+_'...')_________________else_vBoEventMain.EventFunctionName_END_+_'_____________________________'" title="Click here to sort" href="javascript:__doPostBack('ctl01$TemplateBody$WebPartManager1$gwpciNewQueryMenuCommon$ciNewQueryMenuCommon$ResultsGrid$Grid1$ctl00$ctl02$ctl01$btn_ResultsGrid_2_Sort_'_<div_class="styledEventBlock">_____<a_________href="https://www.acoi.ie/iCore/Events/Event_Display.aspx?EventKey='_+_CAST(vBoEventMain.EventKey_AS_VARCHAR(500))_+_'"_____>_________<div_class="content">_____________<div_class="image">_________________<img_src="'_+_REPLACE(vBoEventMain.ImageURL,_'~',_'')_+'"_/>_____________</div>_____________<div_class="details">_________________<div_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)_+_'_________________</div>_________________<div_class="time">_____________________'_+_CAST(DATENAME(hour,vBoEventMain.StartDate)_AS_____________________VARCHAR(20))_+_'_:_'_+_CASE_WHEN_____________________DATENAME(minute,vBoEventMain.StartDate)_<10_then_(_'0'+_____________________CAST(DATENAME(minute,vBoEventMain.StartDate)_AS_VARCHAR(20))_____________________)_else_CAST(DATENAME(minute,vBoEventMain.StartDate)_AS_____________________VARCHAR(20))_END_+_'_________________</div>_____________</div>_____________<div_class="title">_________________'_+_CASE_WHEN_LEN(vBoEventMain.EventFunctionName)_>_100_then_________________(CAST(vBoEventMain.EventFunctionName_AS_VARCHAR(100))_+_'...')_________________else_vBoEventMain.EventFunctionName_END_+_'_____________</div>_________</div>_____</a>_</div>_'','')">' '
Data pager
Data pager
Page size:
 93 items in 24 pages
Show all 93

Member Benefits

Find ACOI presentations, speeches and transcripts from ACOI events...

EDUCATION

LIBRARY

Benchmark qualifications to enhance your career in compliance…

CAREERS

Sign up for the ACOI Compliance Professional register to attract ...

ACOI COMMUNITY

Encompassing events, education and networking opportunities…