Question

4
Replies
333
Views
Erzhan Elemesov (Erzhan_E)
Wargaming.net

Wargaming.net
BY
Erzhan_E Member since 2016 13 posts
Wargaming.net
Posted: May 18, 2017
Last activity: May 30, 2017
Posted: 18 May 2017 11:34 EDT
Last activity: 30 May 2017 13:58 EDT
Closed
Solved

Creating audience using datetime fields

Hello!

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

Thank you!

***Updated by moderator: Lochan to update Categories***

Decision Management
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.