Notifications
Clear all
Topic starter
Good morning,
We are trying to run Meaningful Use Report 12 (Provide Electronic Copy of Health Info) and it is working fine for every department except for Gastroenterology. I keep getting a pop up saying "Bad date format string." I have tried entering the date manually and using the calendar feature, but regardless, I am getting this error.
Does anyone know what the problem could be or how to correct this?
Thanks for any help!
Sarah
Posted : April 23, 2012 12:32 am
We had the same issue with one of our locations of care. The cause is a user entering the wrong date into the 'date request received' box on the Patient Authorization form (in our case: 0123/2012 instead of 01/23/2012--the user typed the date instead of using the calendar button). GE ran a SQL query to help narrow down the possibilities. Give GE the following SR # when you call in: 1-233797532 that should help them out as well.
Posted : April 23, 2012 12:59 am
Topic starter
Hi Sam,
That's exactly what the problem was. It's been driving us crazy!
Thank you!
Posted : April 23, 2012 3:16 am
Can you tell me how to resolve this issue ? We have the same issue. I found the invalid dates for the particular location, and we corrected them on the flowsheet, but the error still occurs. We deleted the invalid dates from the flowsheet, then added them correctly, but can't get past this error. HELP !!
John
Posted : August 26, 2013 3:23 am
For now, you can use the isdate function to eliminate the invalid dates.
Posted : August 26, 2013 11:03 pm
Can you provide a little more detail ? I am not familiar with the isdate function.
Where do I do this ? Thanks.
John
Posted : August 26, 2013 11:34 pm
I believe, in the CheckPatForDrNr formula, only valid values can be taken by using isdate function, something like this
({RPTOBS.HDID} = 22291.00) and (isDate({RPTOBS.OBSVALUE})
Hope this helps
Posted : August 26, 2013 11:46 pm
In addition to changing the line of code in the CheckPatForDrNr formula as mentioned above from
({RPTOBS.HDID} = 22291.00) and
to
({RPTOBS.HDID} = 22291.00) and (isDate({RPTOBS.OBSVALUE})) and
towards the end of the code where it is
(
if (instr(SentDatesList, {RPTOBS.OBSVALUE} + "^") = 0) then
SentDatesList := SentDatesList + ToText(Date({RPTOBS.OBSVALUE})) + "^";
//bSent := true;
);
replace with
(
if (isDate({RPTOBS.OBSVALUE})) then
if (instr(SentDatesList, {RPTOBS.OBSVALUE} + "^") = 0) then
SentDatesList := SentDatesList + ToText(Date({RPTOBS.OBSVALUE})) + "^";
//bSent := true;
);
Posted : August 28, 2013 2:28 am
Thanks for the help ! Worked like a charm.
Posted : August 28, 2013 3:06 am
