Share
ReportHow can contacts who have their birthday "today" and turn 30 be selected in a marketing list? 
You’re offline. This is a read only version of the page.
10
How can contacts who have their birthday "today" and turn 30 be selected in a marketing list? 
Hi A.Wicki,
From your description, I suggest you to use segment.
Here is the relevant document about Segment: https://docs.microsoft.com/en-us/dynamics365/marketing/segmentation-lists-subscriptions
First we need to get the age of the contact.
I have created a text field and called it Real age where I will store the age as you described. Then I have created a Schedule Flow as followed:
Note: When creating, remember to set repeat every to 1 day.
1. Initialize variable
Age Year, Age Month and Age Day stays empty until we fill them later on.
Now Year = int(formatDateTime(utcNow(), 'yyyy'))
Now Month = int(formatDateTime(utcNow(), 'MM'))
Now Day = int(formatDateTime(utcNow(), 'dd'))
2.Add ‘condition’ step. When Birthday has a value, Real age can be calculated.
3.
Those are the following expressions used in this flow:
sub(int(formatDateTime(utcNow(),'yyyy')),int(formatDateTime(items('Apply_to_each')?['birthdate'],'yyyy')))
int(formatDateTime(items('Apply_to_each')?['birthdate'],'MM'))
sub(int(formatDateTime(utcNow(),'MM')),int(formatDateTime(items('Apply_to_each')?['birthdate'],'MM')))
add(12,sub(int(formatDateTime(utcNow(),'MM')),int(formatDateTime(items('Apply_to_each')?['birthdate'],'MM'))))
int(formatDateTime(items('Apply_to_each')?['birthdate'],'dd'))
sub(int(formatDateTime(utcNow(),'dd')),int(formatDateTime(items('Apply_to_each')?['birthdate'],'dd')))
add(31,sub(int(formatDateTime(utcNow(),'dd')),int(formatDateTime(items('Apply_to_each')?['birthdate'],'dd'))))
4. Test
Second, use Segment to get contacts that match today's birthday and will be 30 years old.
At last, create Customer Journey to send birthday card to contacts who have birthday today and will be 30 years old.
Note: Remember to change the time zone to the time zone of your own region.
Using a "dynamic marketing list" in MSD365, contacts are to be found who will be 30 years old "today". They will then receive a birthday card.
With the "advanced search" it doesn't seem to be possible to filter out exactly these contacts.
But maybe I don't know the best way yet.
Maybe you can help me further.
Thank you very much.
Hi A.Wicki,
Could you answer my question thus I can help you further on this case? What exactly do you want to do with this request?
If possible, please write down your specific requirements.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (