Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

date off-by-one issue

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

80 Views

RSS

dennisgcronin

(@dennisgcronin)

Posts: 14

Eminent Member

Topic starter

Not sure what I would search for, so I'm just asking a question.

We have one client where the immunization dates are getting altered. We craft a good string for the MEL IMMUN_ADD function but then when we read it back via MEL IMMUN_GETLIST, the immunization date has been altered to the day before.

The system time on the client/server box looks good. Is there any configuration in Centricity that might affect how dates are processed? The client is in India, not sure geographically where the client/server machine is but it's date is east coast US and the date displayed in Centricity is east coast US.

Any thoughts of what I could look for?

Thanks,

Dennis

Posted : March 28, 2017 12:25 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

In your command, are you coding the AdministeredDate field, and the AdministeredDateType field? They are both recommended.

Posted : March 29, 2017 1:39 am

mkherman

(@mkherman)

Posts: 53

Trusted Member

I remember seeing this awhile ago when testing the GE HTML immunization form that the form used the date and time based on your location. The details are fuzzy, but I do remember we opened a ticket with GE. It was at a previous company, so I can't get the information about the ticket but GE may know about a 'time issue' with immunizations and time zones?
I remember that I was in a different time zone than the servers (both DB and Citrix), and that is what was causing the issue. But it sounds like Server/Clients are set to the same time zone as the local workstations? It was somehow related that the immunizations get added with a time of Midnight so being an hour off moved the date.

Sorry not a huge help, but maybe can help point in the right direction...

Posted : March 29, 2017 3:56 am

dennisgcronin

(@dennisgcronin)

Posts: 14

Eminent Member

Topic starter

mkherman -- time zone certainly is an area of suspicion for me since we're working with a client in India and this has worked fine for many US-based clients. But I'm not seeing anything that sets the time to their local time or that indicates they are in a different geographical location.

I was figuring the DB runs on the same machine but maybe not. That's a good clue.

joeg -- we are setting the date type field to a 'D' indicating day-level precision.

Thanks for your help!

Dennis

Posted : March 29, 2017 5:13 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0