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

MEL Add to Date

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

6 Users

0 Reactions

74 Views

RSS

mlaroche

(@mlaroche)

Posts: 26

Trusted Member

Topic starter

I haven't taken a MEL class yet, but am reading documentation on how to use the language in VFE.

However, I have a form with a dropdown list (DOCUMENT.DUE_NEXT) and it has the following choices: 3 months,6 months,9 months,1 year,3 years,5 years,10 years (for when the patient will need to be back in the office). When the doctor chooses an option from DOCUMENT.DUE_NEXT, I would like it to calculate the date due in the obsterm COLONXTDUE.

I think I'm in over my head on this one! But perhaps someone knows a solution?

Posted : March 13, 2015 3:14 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

You can use the ADDDATES function. To use ADDDATES you just need to specify a date and then the number of years, months and days you would like to add. In CPS go into the help and search for ADDDATES. It has a a couple of good examples. The CPS help is pretty good if you are looking for examples with the built in MEL functions.

Posted : March 13, 2015 4:46 am

jesran

(@jesran)

Posts: 13

Active Member

Also, to test any MEL code quickly you can use personal quicktext before moving it to VFE. In your example we will take bhoover's advice and look at the ADDDATES function example in the Help guide.

So create new personal quicktext ".adddates"

Paste the following into the "With"" field:

{ADDDATES("3/1/1997","2","0","0")}

Then open an update and test it out. As per the Help guide it should return:

"03/01/1999"

Now play around with it. Change the "2" to a "3" and check to see that it now returns:

"03/01/2000"

Calculating dates is tedious but the key is to know which function to use (thank you bhoover) and having a quick method of trial and error (thank you quicktext).

Posted : March 13, 2015 5:04 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Just to add one more thought to this... consider what date you are adding to?

If today is 3/13/15, (the date the doctor is reviewing), but the test results from 1/13/15 are being reviewed. Now, the doctor says recall in six months. Which date do you add six months to? You want everyone to be clear about that. And, you may want it to be clear on your VFE data entry form.

Posted : March 13, 2015 7:13 am

mlaroche

(@mlaroche)

Posts: 26

Trusted Member

Topic starter

Thank you all for your valuable answers! However, I don't think I explained correctly and after joeg's post, I realized I need to make sure I have the correct date it's calculating it from or else the calculation will be off.

So in layman's terms, I have a date field that will populate the LST COLON DT obs term. Once the Doctor puts in that date, that will be the date it calculates from.

Then, the doctor will fill in the DOCUMENT.DUE_NEXT field (3 months,6 months,9 months,1 year,3 years,5 years,10 years).

Lets say he enters the LST COLON DT to be 3/13/15 and DUE_NEXT is 3 months.

I would like the obs term COLONNXTDUE to populate with 6/13/15.

Does this make sense?

Posted : March 13, 2015 10:13 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Here is our Adult Prevention Services form. There is a button called "Update Next Due Dates". There is a code there (case statements) to do what you want to do.

OUT-Adult Prevention Services

Posted : March 17, 2015 4:09 am

JBell

(@jbell)

Posts: 285

Honorable Member

I have been following this and am trying to do the exact same thing, and like mlaroche I have not taken a MEL class.

I am not understanding how to convert the add dates to a string. Can anyone help?

I want to use a document variable or obs I am open to either.

thanks!!

Posted : May 19, 2015 8:12 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Janet, the result of ADDDATES is a string. And the date to add to in the parameters is also a string. If the date you want to use is not a string, you convert it by wrapping it in str().

Posted : May 26, 2015 5:39 pm

Share:

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