Description
Measure the calendar delay between a research query and its recorded closure.
Clinical-research records connect source fields, protocol dates, training, signatures, safety communications and consent versions. A recorded acknowledgment or date predicate does not establish valid consent, authorized delegation or compliance. Source documentation and substantive participant protections require separate review.
Measure the calendar delay between a research query and its recorded closure.
When to use this tool
Use GCP Query Closure Delay when checking the stated benign clinical-research record or date convention.
How to use the tool and how it works
- Enter queryOpenedDate, queryClosedDate. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read signedCalendarDays. Use the output convention below.
Parse real query-open/closed YYYY-MM-DD dates at UTC midnight. Return closed-open calendar days, retaining negative results.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| queryOpenedDate | Query Opened Date | Required. Text; maximum UTF-16 length 8192. Real proleptic Gregorian YYYY-MM-DD; four-digit years 0000-9999 accepted. |
| queryClosedDate | Query Closed Date | Required. Text; maximum UTF-16 length 8192. Real proleptic Gregorian YYYY-MM-DD; four-digit years 0000-9999 accepted. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| signedCalendarDays | Signed Calendar Days | Required. Finite number. |
{
"input": {
"queryOpenedDate": "2026-10-28",
"queryClosedDate": "2026-11-01"
},
"output": {
"signedCalendarDays": 4
}
}Limitations and assumptions
- No chronology requirement is enforced beyond valid dates; actual query closure, data quality and acceptable response times are not determined.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
Alternative or Complementary methods
Review verified protocols, consent and source records under the applicable complete research requirements with qualified responsible personnel for actual study or participant decisions.
References
Similar or alternative tools
- GCP Investigator Training Expiry
Measure the signed date margin to an investigator's recorded training expiry.
- GCP Delegation Task Effective Flag
Check a recorded delegation flag within a closed supplied effective-date interval.