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

Creating Parameter on Clinical Date

Trading Post

Last Post by Anonymous 1 second ago

9 Posts

3 Users

0 Reactions

75 Views

RSS

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

I want to create a parameter based upon DOCUMENT.CLINICALDATE but CR is not allowing me to link the two via Select Expert.

Help?

Posted : January 7, 2013 6:33 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

that's because ClinicalDate is stored as a number. you'll have to reverse engineer the parameter date to a number of the same format before you can use it for comparisons.

Posted : January 7, 2013 6:35 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Okay, I have a new formula created that converts it to a date. How do I build a parameter for a formula value though?

Posted : January 8, 2013 1:58 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

sorry. you need to create a formula converting your parameter date into a number and then compare the clinicaldate to this formula in your select criteria.

Posted : January 8, 2013 2:07 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

you could also do it this way:

{DOCUMENT_1.CLINICALDATE} >= (DateDiff("d", #1/1/1960#, #1/1/2012#) * 24 * 60 * 60 * 1000000)
and {DOCUMENT_1.CLINICALDATE} < (DateDiff("d", #1/1/1960#, #1/1/2013#) * 24 * 60 * 60 * 1000000)

this compares for 1 year. change the parts in red to your begin/end parameters.

Posted : January 8, 2013 2:16 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Could I point two parameters (start & end) to this formula like below? Then use Select Expert to filter to this new formula's value? Are the #'s required around the parameter identifier?

{DOCUMENT.CLINICALDATE} >= (DateDiff("d", #1/1/1960#, #({?Start})#) * 24 * 60 * 60 * 1000000)
AND
{DOCUMENT.CLINICALDATE} < (DateDiff("d", #1/1/1960#, #({?End})#) * 24 * 60 * 60 * 1000000)

Posted : January 8, 2013 3:13 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

take out the # (used to specify a date) and take out the () after the # and it should work.

Posted : January 8, 2013 3:43 am

baj

(@baj)

Posts: 99

Estimable Member

I use the following formula

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));

Then it can be used in record selection formula as:

({@ ConvertDate}>=#10/01/2012# and {@ConvertDate}<=#31/3/2013#)

If dates are parameters record selection formula will be

({@ ConvertDate}>={?DateFrom} and {@ConvertDate}<={?DateTo})

Posted : January 18, 2013 6:18 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Thanks all. I actually went with the below formula.

{@CDate} in {?StartDate} to {?EndDate}

Posted : January 20, 2013 10:16 pm

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