Instructions
The following lists all the supported functions within Clinical Studio TrialKit Computed Fields and the required format to call the function:
...
Date Granularity determines the level of detail you want on your date/time computations. The more detail (granularity), the more converting you will have to do on your formulas. The rules of date/time formulas, however, are pretty straight forward. Clinical Studio TrialKit will convert all date values to the granularity unit. It assumes that all numbers entered are in the proper unit or are converting to another unit for display. Regardless of which granularity level you define, you can still calculate to a lower unit.
...
Second
Minute
Hour
Day (No time calculations)
When Clinical Studio TrialKit evaluates date/time formulas, it takes defined fields, retrieves their values, and converts them to time since 01-01-0001. Depending on the selected granularity, that value is expressed differently.
...
The difference between the Current Date and Date of Birth will be calculated and expressed in hours. However, we do not want age in hours, we want age in years. Therefore we must convert age in hours to age in years. We do this by dividing the age in hours by 24 and then dividing that by 365.25. That gives us the age in years. The following shows the formula in Clinical StudioTrialKit. DM_DATE2 is the CurrentDate and DM_DATE1 is the DateofBirth.
...