We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!
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.