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>_'','')">'
' + (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 + '
'
Data pager
Data pager
12345678910...
Page size:
 100 items in 25 pages
Show all 100
10 Feb 2021
13 : 00
The Fintech Ecosystem
28 Jan 2021
13 : 00
World Data Protection Day
21 Jan 2021
13 : 00
Findings by the Pension Authority Following Onsite Inspections
19 Jan 2021
13 : 00
All You Need to Know on PRIIPs

Member Benefits

Benchmark qualifications to enhance your career in compliance...

Read More

EDUCATION

LIBRARY

Access presentations, speeches and transcripts form ACOI events …

Read More

CAREERS

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

Read More

ACOI COMMUNITY

Encompassing events, education and strategic networking opportunities…

Read More