DOB is going to be a mandatory field in our study, but once they have been entered and the data has been exported, we would like to anonymise the DOB to a standard one for all subjects (ie all 01/01/1900). We also want to do this for hospital number. Does anyone know of the best way for us to do this (preferably without xml as we have no experts here)? Is it possible to run update queries, similar to that in MS Access, or would you need to import the CRFs with updated fields?
Thanks for you help!