@Celeste Canzano @Developer Community Admin 
 

Hi Celeste

I am very eager to participate in this beta exam

As an InterSystems customer, I understand that completion of the online portion of the TrakCare Reporting course is a prerequisite for the exam. I would like to request access to this course so that I can complete the necessary training and be eligible for the certification.

Please let me know the steps I need to follow to gain access.

Thank you for your time and support.

Dear @Toni Crooz ,

you can use this function :

Set totalMinutes = $SYSTEM.SQL.DATEDIFF("mi", startTime, endTime)

But using this you have to convert them back into years,days and hours

Another way you can check out the below query :This gives you no of days

SELECT DATEDIFF(day, TO_DATE('2025-07-20', 'YYYY-MM-DD'), TO_DATE('2025-07-28', 'YYYY-MM-DD')) AS Diff

Name: Harshitha Balakrishna

Location: Based in India

Role & Interests: I work with InterSystems technologies, particularly focusing on TrakCare, Ensemble, and Customizations. My role involves supporting hospital information systems, streamlining workflows, and ensuring seamless data exchange across healthcare systems.

Expertise:

  • InterSystems TrakCare & Ensemble
  • HL7 messaging & healthcare interoperability
  • ObjectScript & MUMPS programming
  • Technical analysis, RCA handling, and issue resolution
    I enjoy helping others troubleshoot tricky integration issues or understand how to optimize workflows using InterSystems solutions.

Fun Fact / Hobbies: I love decoding complex issues like puzzles! Outside of work, I enjoy traveling, working out, and exploring productivity hacks.

LinkedIn: https://www.linkedin.com/in/harshitha-b-4115491a2/

 

To resolve the ERROR #5911: Character Set 'iso-8859-4' not installed, start by checking the MSH-18 field in your HL7 messages, as it may specify iso-8859-4 even if your interface is configured for latin1. Next, adjust the HTTP Operation settings to explicitly enforce latin1 as the character set for consistent encoding.
 

This is a helpful overview! It effectively highlights the strengths of InterSystems IRIS for organizations considering OpenEHR. One point worth expanding could be practical examples or case studies where InterSystems IRIS has successfully integrated OpenEHR with other healthcare standards like HL7 FHIR. Real-world scenarios could offer valuable insights for those evaluating the best approach for their healthcare data solutions.