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 FormattersTable columns overview | Documentation | Clay University