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

How to use a parameter to filter a column based on a formula?

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

79 Views

RSS

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

I need help on how to use a parameter to filter a column which is based on a formula.

I have a column which displays the date of last office visit. I need a parameter so that I can select the patients whose date of last office visit is between, say Jan 1, 2012 to June 30, 2012. Can anyone pls help?

Posted : July 6, 2012 2:56 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Without seeing your code, I'm not sure, but I think it would probably work for you to put the test in the Group Selection Formula for the patients.

Posted : July 6, 2012 3:44 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

something like this:

{DOCUMENT.ClinicalDate} >= EMR_date_to_id({?startdate}) AND
{DOCUMENT.ClinicalDate} <= EMR_date_to_id({?enddate} + 1)

Report Custom Functions:

EMR_date_to_id:

Function (DateTimeVar theDate)
(
DateDiff("d", #1/1/1960#, theDate) * 1000000 * 86400
)

Posted : July 6, 2012 3:51 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Thankyou for the replies. These are the formulas I am using right now.

@LastOfficeVisitDate

WhilePrintingRecords;
dateVar last_off_visit_date:=cdate("1901,01,01");
stringVar physician:="";
if {@ConvertDate}>last_off_visit_date
then
    (last_off_visit_date:={@ConvertDate};
     physician:=TOTEXT({DOCUMENT.USRID});
     );
last_off_visit_date;

@ConvertDate

NumberVar ID := {DOCUMENT.CLINICALDATE};
NumberVar Sec := Truncate(ID / 1000000);
NumberVar Days := Truncate(Sec / 3600 / 24);
Date(DateTime(Date (1960,01,01 ) + Days, Time(0,0,0) + Sec));

What I need is to use a date range and be able to filter the patients whose last office visit dates fall within that date range. Since the record selection condition is based on the LastOfficeVisitDate it is giving the error:

"This formula cannot be used because it must be evaluated later."

Posted : July 8, 2012 11:17 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

So how about the Group Selection Formula, as I suggested above?

Posted : July 8, 2012 11:39 pm

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Sorry, I don't know how to do that. I am looking into it right now. Could you pls explain more.

Posted : July 8, 2012 11:42 pm

Share:

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