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

enable expression using DURATIONDAYS with date field and todays date

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

68 Views

RSS

cbecker

(@cbecker)

Posts: 5

Active Member

Topic starter

I'm working on a basic form to help our community health workers keep track of their patients' specialists appointments in hopes to better aid them in helping others. Essentially I have 9 different sections with obsterms to store a specialist appt name, phone #, date, address, time, and what mode of transport the pt will use and which CHW is responsible for reminder calls, etc.

If anyone has a form they are already using that serves a similar function, please share!

I first need to know if it is possible to use DURATIONDAYS to compare .TODAYSDATE with the LastObsValue that is a date field (vs the LastObsDate of that same obsterm)?

I'm trying to set up function or enable/disable expression that will grey out editfields when the date of a specialist appt is in a future date from today and will allow editing/overwriting when the date of the specialist appt is in the past.

Here's a function I've played with and it only ever keeps the edit field grey, even when the previous value of a date field has already passed.

I'm interested in other ways of approaching this form if my initial form instincts here aren't going to work out into a functional & useful form.

fn lastapp()

{local lastapp= 10000

lastspecapp= DURATIONDAYS(str(.TODAYSDATE),str(lastObsValue("DAT SPEC #1")))

IF lastspecapp <> 0 OR OBSNOW("DAT SPEC #1") <> "" AND lastspecapp < lastapp THEN

lastapp= lastspecapp ENDIF

IF lastapp < 0 THEN "FALSE" ELSE "TRUE" ENDIF}

Thansks, Caroline

Posted : August 22, 2017 8:14 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Here are a couple things I see.

You have not defined your lastspecapp variable scope. Add a line that says "local lastspecapp" near the top of the function.

You do not need to run str(lastobsvalue(...) because observations are already strings, even if they are storing dates.

Functions need to return a value, you are not returning anything.

IF lastapp < 0 THEN return “FALSE” ELSE return “TRUE” ENDIF

Posted : August 22, 2017 12:54 pm

cmahon

(@cmahon)

Posts: 111

Estimable Member

Hi! Just curious - did you ever get this coding to work? If so, would you mind posting the coding? Thanks!!

Posted : January 10, 2019 9:14 am

Share:

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