31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!
Date Validation across CRF sections
I am currently using OpenClinica Version 3.7 to build a study for clinical data collection,
My CRF template (excel workbook) has several sections for 1) Inclusion Criteria, 2) Demographics 3) Blood Test 4) Diagnostic Procedures etc.
I collect the "Date of Visit" data field in the Demographics section and also, "Date of Test", "Date of Procedure", "Date of prescription" data fields throughout all other sections of the CRF.
I would like to know if there is any way I can compare these date fields against the date of visit to validate that both dates are within 12 months of each other.
Further, the "Date of Visit" field is in the "DD-MMM-YYYY" format whereas, all other date fields are in the partial date; "MMM-YYYY" or "YYYY" format.
Any and all advice/suggestions/help is appreciated.