Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • CDMS
  • Castor CDMS Calculations Manual
  • Formatting dates

Convert date formats in EDC/CDMS

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • CDMS
    Castor CDMS Manual Castor CDMS Calculations Manual Frequently Asked Questions Articles for Data Managers Castor CDMS Compliance Release Documents
  • eConsent
    Castor eConsent Manual Castor eConsent Compliance Release Documents
  • SMS
    Castor SMS Manual Castor SMS Compliance Release Documents
  • Castor Connect
    Castor Connect Compliance Release Documents Castor Connect Manual Castor Connect - Participant Quick Start Guide
  • Helpdesk
    News Other Resources Castor products knowledge resources
  • Status page
  • Completing a Study
+ More

Table of Contents

ddmmyyyy mm/dd/yyyy

Study admins can define a custom date format for each institute in the Settings tab.

 

Alternatively, it is possible use calculations to change this format by getting the day (dd), month (mm), and year (yyyy). In this article examples are shown that you can use in your calculation templates. We'll use the date 30 January 2025 as an example throughout the article.

 

ddmmyyyy

For example, if you enter the value 30-01-2025 (30 January 2025) in a date field, this calculation template will convert that to 30012025. Test the calculation template in the calculation tool here.

 

var date = "{your_date_variable}";
var day = date.substr(0,2);
var month = date.substr(3,2);
var year = date.substr(6,4);
day + "" + month + "" + year;

mm/dd/yyyy

For example, if you enter the value 30-01-2025 (30 January 2025) in a date field, this calculation template will convert that to 01/30/2025. Test the calculation template in the calculation tool here.

 

var date = "{your_date_variable}";
var day = date.substr(0,2);
var month = date.substr(3,2);
var year = date.substr(6,4);
month + "/" + day + "/" + year;
edc cdms date format

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Convert a date to CDISC format (dd/mmm/yyyy) in EDC/CDMS
  • Check if entered date is in US format (mm/dd/yyyy)
  • Validating partial dates NK/MM/YYYY in EDC/CDMS
ISO 27001
FDA - 21 CFR part 11
ICH GCP compliant
HIPAA compliant
CDISC
ISO 9001
gdpr compliant

Products & Industries

  • Electronic Data Capture (EDC)
  • ePRO
  • eConsent
  • Decentralized Clinical Trials (DCT)
  • Clinical Data Management
  • Medical Device & Diagnostics
  • Biotech & Pharma
  • CROs
  • Academic Research

Resources

  • Thought Leadership
  • Blog
  • Castor Academy
  • Knowledge Base

 

Company

  • About Us
  • Careers
  • News
  • Contact Support
  • Contact Us

Legal & Compliance

  • Terms of Use
  • Privacy & Cookie Statement
  • Responsible Disclosure Policy
  • Good Clinical Practice (GCP)
  • ISO Compliance Certificates
  • GDPR & HIPAA Compliance
  • Security Statement

© 2022, Castor. All Rights Reserved.

Follow us on social media


Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand