Issues Extracting Updated At Date for CRM Integration

Hey. Not sure if it’s a bug, but I’m trying to extract the date from the “Updated at” column. I need this to push this date to my CRM. The problem:

I don’t see the column when I build the formula (like with /updated at) - even I can see it in my table
And when I type it manually, the formula doesn’t work.

Can you help me figure it out? or find a workaround? please I can extract the data from the Created At column but not the updated at column.

Clay
APP
·
·
When referencing columns in formulas, use / to insert column references rather than typing manually. If "Updated at" still doesn't appear, try referencing it as the exact column name shown in your table. For CRM compatibility, use the Format Date/Time formatter and select Unix Timestamp as your output format. Keep the column type as text rather than date format to avoid formatting issues. If the column still won't reference properly, you can create a formula using the AI Formula Generator by describing what you want to extract from your "Updated at" column.
Sources: Formula generator | Documentation | Clay University Formulas | Documentation | Clay University Referencing dynamic data from other columns | Documentation | Clay University Clay formatters overview | Documentation | Clay University
Elric L.
·
·
I arealdy did and still doesn't work
Elric L.
·
·
https://app.clay.com/workspaces/451915/workbooks/wb_0sxatjk4wHTzg9Rqipk/tables/t_0sxnj3ocgsFvEjkh7py/views/gv_0sxnj3oDTsdV35yAvFF
Elric L.
·
·
i found a workaround by creating a formula with today's date . Not ideal i will use that for now
Clay
APP
·
·
Hello Elric! Thanks for reaching out! Glad you found a workaround. I talked to the team and it is intended behavior to not be able to reference an updated column. The reasons include it being a dynamic column and the risk of creating an infinite loop. The current workaround is the best way forward. Hope that helps!
Elric L.
·
·
thank you!

Issues Extracting Updated At Date for CRM Integration | Clay