Introduction
This integration enables the transformation of date and datetime values using Clay Formatters within Clay workflows. The Format Date/Time action allows users to convert input dates into specified formats, supporting various input and output styles. This functionality is particularly useful for standardizing date representations across different data sources or preparing dates for specific use cases within Clay projects.
Input
Name | Is Optional | Description | Type |
Date | The date or datetime you want to parse. | text | |
Format | The format you want to convert the value to. If you'd like to use your own format, you can choose `Custom` | text | |
true | dynamicFields | ||
Original Timezone | true | The timezone of the original value. Defaults to UTC | text |
New Timezone | true | The timezone of the converted value. Can be left blank if you don't want to change it. | text |
Locale | true | Optionally, you can choose the locale you want to return the data in. This is used to generate date values specific to your locale (e.g. using "octobre" instead of "October" when selecting "French".) | text |
Output
Name | Type |
Formatted Date | text |
Localized Short Date | text |
Localized Date With Month Name | text |
Localized Date With Weekday | text |
Full Date Time | text |
Localized Time | text |
Localized Date Time | text |
Year | number |
Short Year | number |
Day | number |
Month Name | text |
Month Number | number |
Time | text |
Unix Timestamp | number |