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

Creating CRFs for time

Hello,

I am new to the system and creating CRFs at the moment.

Wondering if there is a Data_type for Time; i.e. Hour:Min:Sec, like Data_type for Date; MM/DD/YYYY etc.

If not, what would be a good way to set up items for time?

Thanks
Marinda Fung

Cardiovascular Research Group
University of Calgary

Comments

  • jyearleyjyearley Posts: 17
    Hi Marinda,
    There is not a data type for time.

    We define time values as text fields (ST) and use the following real expression in the VALIDATION / VALIDATION_ERROR_MESSAGE fields: “regexp:/([0-1][0-9]|2[0-3]):([0-5][0-9])/” / “Enter time in format HH:MM on 24 hour clock”

    Remove the quotes.

    This time format does not include seconds. With seconds it would look like this: “regexp:/([0-1][0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9])/” / “Enter time in format HH:MM:SS on 24 hour clock”

    Hope this helps,

    Regards,


    Jeff Yearley
    Senior Clinical Data Manager
    Department of Pediatrics / IICRC
    University of Utah, School of Medicine
    Sent: Tuesday, August 16, 2011 4:10 PM
    To: '[email protected]'
    Subject: [Users] Creating CRFs for time

    Hello,

    I am new to the system and creating CRFs at the moment.

    Wondering if there is a Data_type for Time; i.e. Hour:Min:Sec, like Data_type for Date; MM/DD/YYYY etc.

    If not, what would be a good way to set up items for time?

    Thanks
    Marinda Fung

    Cardiovascular Research Group
    University of Calgary
  • Hello Marinda,
    There is not data type for time as of yet.
    You can represent it as string then set a validation check using a regular expression to check that input is a valid time.
    E.g in the validation column add this
    regexp: /[0-1]\d:[0-5]\d |2[0-3]:[0-5]\d /
    it will check for time in 24hr format.
    Hope it helps.
    with kind regards,
    Max.
    ------------------------------------------------
    Max Kimambo
    Straßmannstr 13a,
    10249, Berlin.
    T: +493057706550 ext 1501
    ------------------------------------------------
This discussion has been closed.