Parsed datetime
What this tool does
This tool takes a date written in any common text format and breaks it down into specific parts like the day, month, year, and hour. It works automatically without needing you to specify the format first, making it easy to use with different date styles.
Please note that if the input text cannot be recognized as a valid date, the tool will not return any date parts and will instead indicate that the operation failed.
Common uses
- Converting a messy date entry from a form into structured data for further processing.
- Extracting just the year or month from a full date string for filtering or grouping records.
Input data
| Parameter | Required | Example | Description |
|---|---|---|---|
date | Yes | 20/01/2018 | Enter the date as plain text in a common format (for example, '20/01/2018' or '1975-05-20 08:00:00'). This field is required. |
Output data
| Field | Description |
|---|---|
day | The day of the month as a number (for example, 1, 15, or 31). |
formatted | The date rewritten in a standard 'Year-Month-Day' text format (for example, 2018-01-20). |
hour | The hour of the day as a number from 0 to 23. |
minute | The minute of the hour as a number from 0 to 59. |
month | The month number as a number from 1 to 12. |
quarter | The quarter of the year as a number from 1 to 4. |
second | The second of the minute as a number from 0 to 59. |
week | The week number of the year as a number. |
weekday | The name of the day of the week (for example, Monday or Friday). |
year | The full year as a four-digit number (for example, 2018). |
yearday | The day number within the calendar year, ranging from 1 to 365 (or 366 in a leap year). |