We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Date calculation

Please guide on how to derive the dayspan from start date and end date.

Comments

  • GerbenRienkGerbenRienk Posts: 838 ✭✭✭
    It depends on what you want to use it for. If you want to write a validation that for example the difference should not be more than x days, you can use an expression like:
    OID_DATE2 gt OID_DATE1 + x
    Should you however want to display the difference in your CRF, you can do this by adding some javascript. An example can be found at
    http://www.trialdatasolutions.com/tds/howto/datediff.jsp
    Hope this helps,
    Gerben Rienk
This discussion has been closed.