Home

News

ICQ Autumn 2022 is now available to read online

9/20/2022 Read More

Compliance Institute's Newsletter for September 2022 is Now Available Online

9/1/2022 Read More

Niall Gallagher Professional Diploma in Compliance Scholarship

8/31/2022 Read More

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" translate="no" href="javascript:__doPostBack('ctl01$TemplateBody$WebPartManager1$gwpciNewQueryMenuCommon$ciNewQueryMenuCommon$ResultsGrid$Grid1$ctl00$ctl02$ctl01$btn_ResultsGrid_2_Sort_'_<div_class="styledEventBlock">_<a_href="https://www.compliance.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
1 2 3 4 5 6 7 8 9 10 ... Page size: 4 10 20 50 Change page size 144 items in 36 pages

Compliance Institute Annual Conference

Leading the conversation in Crypto Compliance

4 Oct - 6 Oct 2022

IFCA International Compliance Conference 2022

Ethics: The missing E in ESG Investing - Free to members

view all events

Member Benefits

Benchmark qualifications to enhance your career in compliance...

EDUCATION

LIBRARY

Access presentations, speeches and transcripts form Compliance Institute events …

CPD Events

Benefit from a wide range of discounted Compliance Institute CPD Events...

Designations

Compliance Institute Designations are considered the benchmark designation for many roles in compliance…

Become a member