Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Change Text Cell Format to YYYY-MM-DD HH:MM:SS in Spreadsheet | Clay

Change Text Cell Format to YYYY-MM-DD HH:MM:SS in Spreadsheet

·Oct 24, 2025 03:55 PM·

How can I change the display format of a text cell from 20 Oct 2025, at 14:13 this to that 2025-10-20 14:13:00?

Loading attachments

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
Use our Format Date/Time formatter to convert your date format:
1. Add a new column and select Format Date/Time from the formatters
2. Input the date - select your "LinkedIn Reply receive" column as the source
3. Choose format - select "Custom" and enter your desired format pattern for "2025-10-20 14:13:00"
4. Configure run settings - by default, new rows will automatically be formatted
5. Run the enrichment to apply the date formatting [1]
The formatter supports various input and output styles and can transform dates into specified formats, which is exactly what you need for standardizing your date representation. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Oleksii K.
·
·
i have an error
Loading attachments
Clay Support
APP
·
·
The error occurs because the Date column type can't parse your text format "20 Oct 2025, at 13:08." Instead of changing the column data type to Date, use the Format Date/Time formatter:
1.
Keep your new column as Text data type (not Date) [1]
2.
Add the Format Date/Time formatter to convert your "LinkedIn Last Message" column [2]
3.
Select "Custom" format and enter your desired pattern for "2025-10-20 14:13:00" [3]
4.
Run the enrichment to apply the formatting
This approach transforms the date format while keeping it as text, avoiding the conversion error you're experiencing.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help resolving the date format conversion issue, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other challenges you’re facing?