consent date and email

[rbiri]

Hello

I am trying to getthe latrst consent date for each email from the last 3 years.

I am not sure how to use the function properly

ex: max(consetDate) 

but how can I group by email at the same time?

[ParthaSarathy · Accepted solution]

Hi @rbiri ,

Have you tried the solution provided in below thread?

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-retrieve-al...

In the Deduplication, use consentDate instead of last modified.

The result transition of Deduplication activity will give you the latest consent date for each email.