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

Clinical Date Formula Error

Page 1 / 3 Next

Trading Post

Last Post by Anonymous 1 second ago

34 Posts

3 Users

0 Reactions

214 Views

RSS

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

I am trying to run a report, but I am getting the following error: "The number of days is out of range". The formula I am using is below.

NumberVar sec := Truncate({DOCUMENT.CLINICALDATE} / 1000000);

DateTime(Date (1960,01,01 ) +Truncate({DOCUMENT.CLINICALDATE} /1000000/3600/24), Time(0,0,0) + sec);

In the selection criteria for @ClinicalDate I have "LastFullMonth".

Posted : November 10, 2013 11:10 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I usually use the following:

NumberVar ID := {DOCUMENT.CLINICALDATE};
NumberVar Sec := Truncate(ID / 1000000);
// Convert seconds to days
NumberVar Days := Truncate(Sec / 3600 / 24);
// Convert days to a date (and time)
DateTime(Date(1960,01,01) + Days , Time(0,0,0) + Sec)

Posted : November 11, 2013 12:27 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Tried your formula: Error: The number of days is out of range.

I tried changing the filter for DOCDATA.DATA="*XXX*" (this data works) into the report and it runs, but it wont run with DOCDATA.DATA="*PATIENT INSTRUCTIONS*" for some reason.

Posted : November 11, 2013 12:44 am

baj

(@baj)

Posts: 99

Estimable Member

Your formula is correct. Can you post your filter criteria?

Posted : November 11, 2013 12:46 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

The filters is from the same report. It's the DOCDATA.DATA that makes the difference on whether the report runs or not.

Non Working Report

{DOCUMENT.DOCTYPE} = 5.00 and
{@ClinicalDate} in DateTime (2011, 08, 01, 00, 00, 00) to DateTime (2012, 03, 01, 23, 59, 00) and
{DOCUMENT.STATUS} = "S" and
{DOCDATA.DATA} like "*PATIENT INSTRUCTIONS*" and
{DOCUMENT.SUMMARY} = "Handout Printed"

Working Report

{DOCUMENT.STATUS} = "S" and
{DOCDATA.DATA} like "*VIS*" and
{DOCUMENT.DOCTYPE} = 5.00 and
{@ClinicalDate} in DateTime (2011, 08, 01, 00, 00, 00) to DateTime (2012, 03, 01, 23, 59, 00) and
{DOCUMENT.SUMMARY} = "Handout Printed"

Posted : November 11, 2013 1:09 am

baj

(@baj)

Posts: 99

Estimable Member

I have no clue. But, are you getting the same error now, or are you not getting any records?

Posted : November 11, 2013 1:24 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Same error, it starts to run then errors out after reaching certain # of data.

Posted : November 11, 2013 1:29 am

baj

(@baj)

Posts: 99

Estimable Member

Is there any chance that the data contains invalid dates?

Posted : November 11, 2013 1:32 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I would say to write another crystal report to show what the data is in the fields.

Do not select by clinical date, but display

docdata, clinical date field, computed clinical date field

You might have some 'bad' data.

Posted : November 11, 2013 1:32 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

baj, no I wouldn't think so since its pulling from the same filter: DOCTYPE & SUMMARY which the dates work for the {DOCDATA.DATA} like "*VIS*".

Posted : November 11, 2013 2:12 am

baj

(@baj)

Posts: 99

Estimable Member

Can you check this by just displaying all dates (without using filter on clinical date) as Joseph has suggested in his post?

{DOCUMENT.DOCTYPE} = 5.00 and
{DOCUMENT.STATUS} = "S" and
{DOCDATA.DATA} like "*PATIENT INSTRUCTIONS*" and
{DOCUMENT.SUMMARY} = "Handout Printed"

Posted : November 11, 2013 2:52 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

The DOCDATA.DATA like "*PATIENT INSTRUCTIONS*" works with the below filter in a new report created. The report that I last ran was last year and haven't ran it again til today.

Current Filter:

{DOCUMENT.SUMMARY} = "Handout Printed" and
{DOCUMENT.DOCTYPE} = 5.00 and
{DOCDATA.DATA} like "*PATIENT INSTRUCTIONS*"

The DOCDATA.DATA data is different compared to how it was in 2012 compared to todays? But don't see how the date formula can be a factor?

Posted : November 11, 2013 3:24 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Someone may have created a document, over-riding the default date/time. That is why you want to create a report to simply list all documents selected by your docdata filter, and list out the fields.

Posted : November 11, 2013 3:38 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

After starting from scratch, I was able to list the clinical date into the report, but its only showing a few records whereas the report back in 2012 was much more!!

Posted : November 11, 2013 3:44 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I would recommend - turn off all selection rules. Start form a really big list, then slowly put filters back in place. You should have as much data as in 2012, at least to begin with.

Posted : November 11, 2013 3:46 am

Page 1 / 3 Next

24 Forums
9,942 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