Description
Measure a clinical query's signed calendar age at a cutoff.
Research records need explicit date origins, visit definitions, consent context and observation states. Study day one can omit day zero, whereas ordinary elapsed-day arithmetic starts at zero. A supplied report label or date difference is not a validated clinical finding or a complete research endpoint.
Measure a clinical query's signed calendar age at a cutoff.
When to use this tool
Use Clinical Query Age At Cutoff when you already have queryOpenedDate, cutoffDate and need to measure a clinical query's signed calendar age at a cutoff.
How to use the tool and how it works
- Enter queryOpenedDate, cutoffDate. 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 UTC dates; return cutoffDate-queryOpenedDate in days.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. |
| cutoffDate | Cutoff 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",
"cutoffDate": "2026-11-01"
},
"output": {
"signedCalendarDays": 4
}
}Limitations and assumptions
- Negative gaps are retained. No query, response, data lock, quality issue, deadline or valid analysis cutoff is verified.
- 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 the protocol, source documents and study-day convention before combining records. Use the complete research and clinical assessment for interpretation; local labels, offsets and comparisons do not establish data validity, participant status or an outcome.
References
Similar or alternative tools
- Clinical Record Source Correction Marker
Qualify an explicit clinical-record correction reference by source version.
- Clinical Endpoint Source Key
Qualify an explicit clinical endpoint identifier by source version.