How to Split date from current System date?
In order to send Birthday Notification to the customers who registers ,I need to compare the current system date and month with the DOB specified by the customer during the registration how to configure this requirement regardless of the year.
***Edited by Moderator: Lochan to update platform capability tags***
Accepted Solution
Updated: 6 Jun 2022 8:12 EDT
Pegasystems Inc.
IN
Below format function will take 20200110 and return 01-10.
Below format function will take 20200110 and return 01-10.
@String.substring(@FormatDateTime(@getCurrentDateStamp(),"yyyymmdd","mm-dd-yyyy"),0,5)
To achieve the full requirement you can use an activity, which can be called from agent or user action.
1. Loop through the existing customers' results (Pagelist or RD or RDBList) which contain Name, DOB, Email, Phone.
2. Within the loop,
- Format the DOB and CurrentDate to mm-dd or any desired format, and save to Params for comparison, using the mentioned format function above.
- Compare the formatted values for a match.
- If values are same, append the emailID to Param.To (It should be a comma separated emailID string.
3. Call SendSimpleEmail or any other utility already available in your project with necessary Parameters.
Incessant Technologies
IN
Use a function that takes input parameter as DOB and compare the month and then date to return a boolean to check if the date and month is same.
Accepted Solution
Updated: 6 Jun 2022 8:12 EDT
Pegasystems Inc.
IN
Below format function will take 20200110 and return 01-10.
Below format function will take 20200110 and return 01-10.
@String.substring(@FormatDateTime(@getCurrentDateStamp(),"yyyymmdd","mm-dd-yyyy"),0,5)
To achieve the full requirement you can use an activity, which can be called from agent or user action.
1. Loop through the existing customers' results (Pagelist or RD or RDBList) which contain Name, DOB, Email, Phone.
2. Within the loop,
- Format the DOB and CurrentDate to mm-dd or any desired format, and save to Params for comparison, using the mentioned format function above.
- Compare the formatted values for a match.
- If values are same, append the emailID to Param.To (It should be a comma separated emailID string.
3. Call SendSimpleEmail or any other utility already available in your project with necessary Parameters.