General
      Back to home
      1. Roseman Labs help center
      2. Using Roseman Labs
      3. General

      Understanding dates in the platform

      This article explains how dates work in the platform and the supported formats when importing data. Whether you're importing data ad-hoc or responding to a data request, proper configuration of date formats ensures accurate processing.

      While the platform allows importing dates with times, only the date portion will be available in the analysis engine.

      Configuring Date Formats

      When you upload your data, you can define the format for date columns by clicking the Column settings button in the Data Layout T                                                                                      able. This applies to both ad-hoc data imports and data requests.

      You can choose from three primary categories of date formats:

      • DD-MM-YYYY (e.g., 31-12-2024) - European
      • MM-DD-YYYY (e.g., 12-31-2024) - American
      • Year First (e.g., 2024-12-31) - Year-first

      These categories represent the most commonly used formats, but the platform supports a broader range of date formats, which we will show below.

      Supported date formats

      The platform’s parsing system allows for flexible date input. Below is a breakdown of all the formats supported:

      ISO formats (Year-first)

      The platform supports all ISO 8601-compliant date formats, including:

      • Full ISO formats (e.g., 2024-12-31T23:59:59, 2024-12-31T23:59:59.123Z)

      Excel Formats (Year-first)

      Common Excel date-time formats are also supported:

      • yyyy-M-d
      • yyyy-M-d HH:mm:ss
      • yyyy-M-d HH:mm:ss.SSS
      • yyyy-MM-dd HH:mm:ss
      • yyyy-MM-dd HH:mm:ss.SSS

      Pandas formats (Year-first)

      For data science workflows, Pandas-compatible formats are accepted:

      • yyyy-M-d HH:mm:ss.SSSZZ
      • yyyy-MM-dd HH:mm:ss.SSSZZ

      Database formats (Year-first)

      Database-exported formats, often including time zone offsets, are supported:

      • yyyy-M-d HH:mm:ss.SSS ZZZ
      • yyyy-MM-dd HH:mm:ss.SSS ZZZ

      European formats

      European-style formats where day comes before month:

      • d-M-yyyy (e.g., 5-1-2024)
      • d-M-yyyy HH:mm:ss
      • dd-MM-yyyy
      • dd-MM-yyyy HH:mm:ss

      American formats

      American-style formats where month comes before day:

      • M-d-yyyy (e.g., 1-5-2024)
      • M-d-yyyy HH:mm:ss
      • MM-dd-yyyy
      • MM-dd-yyyy HH:mm:ss

      If your data contains formats outside of these supported patterns, you may encounter parsing errors. Ensure the data matches one of the formats listed above.

      Thank you for taking the time to read this article. If you have feedback or need more information on specific topics, feel free to leave it below or reach out to support@rosemanlabs.com.