Data Management & Editing · TOOL GUIDE

DateTime Conversion

Open Quantly ↗

Understand the method. Use it with confidence.

Convert columns to proper DateTime format. Quantly runs the method against your active analysis context and returns structured results for review and interpretation.

01

When to use it

Use this tool while preparing an analysis-ready dataset or correcting a known data issue.
Use it only when the selected variables and study design match the method's requirements.

02

How to use it

  1. Open the tool from the Quantly Tools panel.
  2. Confirm the active dataset and analysis session.
  3. Set Column to Convert (Required): Select the column containing date/time values.
  4. Set Format String (Optional) (Optional): e.g., '%Y-%m-%d' or '%d/%m/%Y'. Leave empty to auto-detect.
  5. Set Day First (e.g. 31/01/2020) (Optional): Check this if your data uses DD/MM/YYYY format (common outside US).
  6. Set Year First (e.g. 2020/01/31) (Optional): Check this if your data uses YYYY/MM/DD format.
  7. Set Error Handling (Required): How to handle invalid values that cannot be converted.
  8. Set Save as New Dataset (Optional): Create a new dataset with the changes instead of modifying the current one.
  9. Review optional or advanced settings and keep defaults unless your design requires a change.
  10. Run the tool, inspect warnings and diagnostics, then save or export the result with its assumptions.
03

How to interpret results

Confirm the affected rows and columns before saving. Review the output dataset and warning counts; transformations change data rather than proving a statistical conclusion.