245
Hello Community,
i am working on some different Use cases with our customer and one of the tricky parts is the segmentation on birthdays.
If I am building my query depending on "within last month" the segmentation is working on the year 2020. Of course my segment isn't born in 2020, instead of that
i want to segment all people which have birthday in december. How can I manage that? There is no option to build the query on a month or a year?
Regards,
Joannis
amazing! didn't even know this function on dates. Thanks for that ;)
Hi Joannis,
You could create a whole number field to Contact entity to support the extension:
1. Create the field called "Birth Month".
2. Import Dynamics 365 Workflow Tools solution.
3. Extract month of date and time field with Month function of the solution:
https://github.com/demianrasko/Dynamics-365-Workflow-Tools/blob/master/docs/DateFunctions.md
4. Create a workflow for Contact:
Step 1: Set birthday of contact as input parameter to the function:
Step 2: Update the custom field with output of the function:
Now the query can be based on the field value:
Regards,
Clofly
Hi Joannis,
You can do this by clicking the two little arrows on the right (next to the date checker) and check "Partial Date".
Check my screenshot below:
Good Luck with segmenting ;)
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (