Skip to main content
Format Date/Time with Clay Formatters

Transform a given date or datetime into a given format.

Updated over 3 months ago

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

Did this answer your question?