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:
 95 items in 24 pages
Show all 95
16 Dec 2020
13 : 00
Sustainable Finance – An Overview of EU Policy and Upcoming Legislative Proposals
15 Dec 2020
12 : 00
Liquidity, Challenges Facing the Global Markets
8 Dec 2020
13 : 00
Fintech Risk & Compliance – ‘Outsourcing Risks’
2 Dec 2020
13 : 00
FinCEN Files Unveiled – How Oligarchs, Criminals and Terrorists Hide and Move Their Money

Member Benefits

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

Read More

EDUCATION

LIBRARY

Benchmark qualifications to enhance your career in compliance…

Read More

CAREERS

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

Read More

ACOI COMMUNITY

Encompassing events, education and networking opportunities…

Read More