Notifications
Clear all
Topic starter
Does anyone know of a way to update problems without a start date? I am having trouble with some of MU measures because our users were instructed to leave this blank when we first installed the system.
Thanks V
Posted : May 26, 2016 9:57 am
You could update it using SQL.
something like this SHOULD work:
I am on Oracle but it looks like you are on MSSQL based on your CPS tag. I can try to mock up a SQL command but I can not promise it will work. I am not sure about the convert_id_to_date(). It is a function in oracle, it should be in sql as well. The update should set the date that the problem was added to the list as the onset date if the onsetdate is null.
begin tran
update problem set onsetdate = convert_id_to_date(problem.sprid) where onsetdate is null;
--Make sure you have updated the appropriate number of rows before running commit
--run it after hours as it will lock the problems table until you commit the transaction
commit;
Posted : May 31, 2016 8:29 am
