Start a conversation

Formatting dates

  • Convert date formats

    If you're using date fields, then the date format will always be dd-mm-yyyy. You can use calculations to change this format by getting the day (dd), month (mm), and year (yyyy). In this article exampl...

  • Check if entered date is in US format (mm/dd/yyyy)

    In the United States, the date format begins with the month and ends with the year (mm/dd/yyyy). If you want to use this format, we recommend you to use a text field. In this text field, you can use t...

  • Convert a date to CDISC format (dd/mmm/yyyy)

    Dates entered into Date fields are stored in the format dd-mm-yyyy. The calculation template below can be used to convert a date field entry into CDISC format (dd/mmm/yyyy).  For example, if 30-01-202...