Woah that's a very cool article! They are great best practices to take note while writing any code.

@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.

@Developer Community Admin 

I am facing the same issue as well, even though I do not have any other account associated with the new email, the system does not allow me to change the email.

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

Thanks! It's a cool article 😄 I'm gonna try it.

u can also use $ZDATE(+$HOROLOG,4)

replace horolog with paper.PAPERDob

you can try DOB=$ZDATE(paper.PAPERDob,15,,4) 

dear @Celeste Canzano 

Can anyone take this beta test? or only those who holds an active SQL Specialist certification is eligible for this?

Regards,

Harshitha

👏

😀👏

Hi @DcAiBot !
Welcome to developer community :)

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.
 

Looking forward to exploring this! Are there plans to integrate partitioning features with existing IRIS analytics tools?