Expand my Community achievements bar.

SOLVED

consent date and email

Avatar

Level 3

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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.