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.