Posted: 18 May 2017 11:34 EDT Last activity: 30 May 2017 13:58 EDT
Creating audience using datetime fields
Do you know how I can put criteria in audience creation section so that I can select those who activated two days ago from current date. I have activation_dt field in my customer table and it datetime format and I also can use current datetime function in Pega. But operating with those two variabels using function difference in days I'm not getting what I want. Be precise using them I need calculate hours and minutes to get what I want. And I wand following thing: my segment is calculating everyday at 7 am, and I want in this segment those whose activation date was the date of 2 days previouse than today. If today 18 of May 2017 then I want in my segment those who has activation_td 16 May 2017 00:00:00 <=avtivation_dt<=16 May 2017 23:59:59 in short those who has date 16 May 2017, tomorrow (19May2017) I want in my segment all those who have activation date 17 of May 2017 and so on
I would appreciate if know clue how I can make it with standart functions that are available in audience creation part.
I'm using pega marketing 7.13, prpc 7.1.9
***Updated by moderator: Lochan to update Categories***
In Pega Marketing 7.13 the Visual mode of creating Segments supports the relative date type criteria you are descibing. The Pega Marketing 7.13 User Guide has more details on configuring this type of criteria. The section "Configuring Dates and Times" of Chapter 5: Segments describes the supported options. You can find the guide here: https://pdn.pega.com/documents/pega-marketing-713-user-guide