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

Comparing date and time in patient banner

General Discussion

Last Post by DavidShower 5 years ago

3 Posts

3 Users

0 Reactions

67 Views

RSS

dmasucci

(@dmasucci)

Posts: 2

Active Member

Topic starter

I have a piece of code and I'm trying to compare the date and time of the observation term entries but it appears MEL is reading it as text and not as a date time. Does anybody know how I can get this to read the time accurately?

{if last_signed_obs_datetime("IMLOCSECTION") > last_signed_obs_datetime("RELEASE DATE") then "" else last_signed_obs_value("RELEASE DATE") endif}

As an example if the last observed date and time for IMLOCSECTION is 10/15/2019 11:34:00 and the release date is 10/15/2019 6:19:00 it is still pulling the release date

Posted : October 17, 2019 6:13 am

chris.cole

(@chris-cole)

Posts: 12

Active Member

Try this. I've surrounded your references to last_signed_obs_datetime with the VAL data symbol. In the original fn the > operator is behaving as though it's a string comparison which doesn't behave quite the way people anticipate. I'm sort of surprised that my function below works so be sure to test it thoroughly as I only tested once.

{if val(last_signed_obs_datetime("IMLOCSECTION")) > val(last_signed_obs_datetime("RELEASE DATE")) then "" else last_signed_obs_value("RELEASE DATE") endif}

Posted : October 22, 2019 5:30 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

This would probably work too:

{if DURATIONDAYS(last_signed_obs_datetime("IMLOCSECTION"),last_signed_obs_datetime("RELEASE DATE"))< 0 then "" else last_signed_obs_value("RELEASE DATE") endif}

Posted : October 23, 2019 11:38 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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