Does anyone know how do a calculation and display in VFE?
We are looking to calculate at every visit how many days it is from the date of onset. This will only be done for certain diagnosis codes.
Thanks,
Lisa
The function is durationdays.
{DURATIONDAYS(str(date1),str(._TODAYSDATE)}
where date1 is the date of that particular problem's onset.
Before going too much further, this will give an answer for number of days. So, if someone has had diabetes for 12 years, the answer would be 4383 - not very pretty. So, would you want to see a duration in days, months, years, ???
The physician would only like to see the days since she only cares about the first 365 days.
I am going to try your formula for just days.
Thanks so much for your help.
How would I pull this by a particular problem? Or containing ICD code?
Your will need to use the function {PROB_AFTER("delimited","dat")} and to process the results into an array. I know that there are some other examples on here with taking lists into arrays. [Trying to point you in the direction, but time-pressed to write out all the syntax.] So, you would execute the PROB function, then process the array elements of each problem, and while doing so execute the DURATIONDAYS function.
Anyone that may have a starting point of the above mentioned array please send along. I am kind of stuck.
Thanks.
I am interested in getting a pop up to indicate that there are problems on the problem list with no start date. Can you help me with a workflow for this?