Question
Accenture
SG
Last activity: 11 Jun 2018 8:35 EDT
How do you create an Audience of customers whose birthdays are next month?
In Pega Marketng, I'm trying to create an audience segment where one of the criteria is that the customer's birthday is next month. Currently the way we are doing it is by using the following equality:
where we are using the following OOTB functions from calculation builder:
- Subtract: Subtract [numeric value 1] From [numeric value 2]
- Month Number: The month number of [Date Value]
- Current Date Time: The current system date and time as a DateTime value
So for example, today's date is April 26, 2018 and the customer's birthday is May 1, 1980, we get Subtract (4) From (5) which gives us 1. Thus this customer will be part of the audience segment.
However this formula does not work when the current month is December and we are trying to get customers whose birthdays are in January, be cause we will get Subtract (12) From (1) which gives -11.
In Pega Marketng, I'm trying to create an audience segment where one of the criteria is that the customer's birthday is next month. Currently the way we are doing it is by using the following equality:
where we are using the following OOTB functions from calculation builder:
- Subtract: Subtract [numeric value 1] From [numeric value 2]
- Month Number: The month number of [Date Value]
- Current Date Time: The current system date and time as a DateTime value
So for example, today's date is April 26, 2018 and the customer's birthday is May 1, 1980, we get Subtract (4) From (5) which gives us 1. Thus this customer will be part of the audience segment.
However this formula does not work when the current month is December and we are trying to get customers whose birthdays are in January, be cause we will get Subtract (12) From (1) which gives -11.
Are there any better ways to go about this? In the future we may also need to do filtering involving other dates where the year is not relevant (hence we cannot use the function Difference in Months) and would really rather not worry about special cases. I also feel that the solution above is not really intuitive to a marketing user.
I'm thinking along the lines of
MonthNumber( Cust.cust_dob ) = MonthNumber(CurrentDate+Months(1))
But I'm unsure how to implement the Months(1) part.
Thanks
Virtusa PVT Ltd
IN
Please see if the below function works:
The difference in days between [Earlier Date Value] and [Later Date Value
Please see if the below function works:
The difference in days between [Earlier Date Value] and [Later Date Value
Accenture
SG
With Current Date as the Earlier Date Value and Birthday as the Later Date Value? This won't work. For example if the birthday is May 1, 1980 and I am using April 26, 2018 as the current date, the function will just return the customer's age in days, which is about 14000 days.
Pegasystems Inc.
IN
How about extracting the month from the date of birth using Month() function and then map them to a decision table to get the value for the segment.