.png){kind=logo}
Generating Current Timestamp in ISO Format for Clay Table Column
How can i generate the current timestamp in a column inside a Clay Table in valid ISO format?
You can generate a timestamp in ISO format using Clay's Format Date/Time formatter. Here's how: 1. Add a new column to your table 2. Set the column data type to "Number" or "Text" 3. Use the Format Date/Time formatter on this column 4. When configuring the formatter: • Input the current date/time • Select "Unix Timestamp" as the output format • Leave the timezone settings as UTC (default) • The formatter will automatically update for new rows if auto-update is enabledThe formatter will handle the conversion and ensure your timestamps are in the correct format. You can choose from various output formats including Unix Timestamp and Full Date Time depending on your specific ISO format needs. Sources: Format Date/Time with Clay Formatters Table columns overview | Documentation | Clay University
Great! Let me know if you have any other questions.