Notifications
Clear all
Topic starter
How can I pull the date of service into a crystal report? Does anyone happen to have an example report with this?
Thanks in advance!
Posted : July 26, 2018 4:37 am
FOR CPS database
You'll need to create a formula field and put in 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 : July 26, 2018 4:45 am
Topic starter
thanks for the quick response! is it the same for an EMR database?
Posted : July 26, 2018 4:48 am
