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

Add dates using document variable

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

53 Views

RSS

JBell

(@jbell)

Posts: 285

Honorable Member

Topic starter

I am trying to enter a surgery date and the calculate the 90 day global period into another field.

I am struggling with the add dates function and using the document variables in how to write this, any help appreciated.

Here is what I have now. I would like to take the date in the DOCUMENT.SURGERY_DATE field and add 90 days to it and store the result in the DOCUMENT.GLOBAL_PERIO field.

{ADDDATES(str("DOCUMENT.SURGERY_DATE"))"0","0","90")
DOCUMENT.GLOBAL_PERIO

thanks in advance!!

Posted : November 9, 2015 3:11 pm

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Try this:

In the Mel section of your Display Field:

{fnGlobalPerio()}

====================================================================

In the code window of the form:

fn fnGlobalPerio()
{

local sDocDate=sub(str(DOCUMENT.SURGERY_DATE),1,10)
local sGPDate=ADDDATES(sDocDate,"0","0","90")

DOCUMENT.GLOBAL_PERIO=sGPDate

return sGPDate
}

Posted : November 10, 2015 5:06 am

JBell

(@jbell)

Posts: 285

Honorable Member

Topic starter

Thank you that worked great.

If you have a few minutes can you explain what happened here. This code is more than I have ever done before and I am not quite sure how it all works. If you do not, no worries.

thanks!

Posted : November 10, 2015 8:34 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Firstly, I find it easier if you are trying to accomplish multiple things to a) put it into a function instead of trying to cram it all into the Mel section of a field and b) break it down into smaller steps with the use of Local variables. This helps to avoid typos such as adding an extra parentheses, which is one of the problems you had in you original code.

Secondly, I forget the reason why I started "sub"stringing my dates prior to using them in AddDates, but I am pretty sure I was getting either errors or funky results either due to extra spaces at the end or possibly a time section reflecting 12:00:00 am at the end.

You could even skip the line "DOCUMENT.GLOBAL_PERIO=sGPDate" if you are actually not using this document variable anywhere else in your form. I just included it because I thought you still might need to set the value to your calculated date if you were still using it elsewhere.

Posted : November 10, 2015 10:28 am

JBell

(@jbell)

Posts: 285

Honorable Member

Topic starter

Thank you!!

Posted : November 10, 2015 10:53 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