How to Deduplicate and Keep the Latest Record in a Table Sorted by Created Date

if I have duplicates, I can dedupe, and the first record on the table will be keep and the next ones deleted as duplicates If so, can I sort by createdDate desc, so I can keep the latest record instead?

4 comments

Clay Team
APP
·
·
Hi Esteban, thanks for getting in touch! Yes, this will work
Esteban L.
·
·
how do I access to createdDate in formula? because I can't see it in Sort, so I believe I need to creata a formula field base on createdDate and then sort by that
Esteban L.
·
·
moment({{created_at}}).format('MM/DD/YYYY') ?
Clay Team
APP
·
·
You can add a column designed for this purpose