How can I exclude recipients with the event date from broad log table and rec-create-date from the feature purchased table? | Community
Skip to main content
R
rvnth
Level 5
February 27, 2024
Solved

How can I exclude recipients with the event date from broad log table and rec-create-date from the feature purchased table?

  • February 27, 2024
  • 1 reply
  • 1069 views

I'm attempting to exclude broadlogs based on the eventDate and the REC_CREATE_DATE plus one day, but I'm encountering an error.

 

 

 

My workflow retrieves records created the day before if it's running today and sends emails accordingly. Therefore, I aim to exclude users who received an email yesterday, and their REC_CREATE_DATE is the day before yesterday. Please advise.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by LakshmiPravallika

Correct @rahuldon1 , I have used the function in similar way mentioned in the screen shot but getting an error Unknown see definition of schema.


Hi @rvnth ,

 

From the error screenshot, it looks like you are getting input from a temp Table (Intersection activity) and trying to check the condition. Please check the Internal name of the Intersection activity in the Fork is connected properly.

 

Regards,

Pravallika.

1 reply

R
rahuldon1
February 27, 2024

@rvnth  Hi try to add To_Date() function on date conditions.

R
rvnthAuthor
Level 5
February 28, 2024

Hi @rahuldon1 ,

I am receiving the same error as below when I try to use AddDays or DateOnly

 

 

Please suggest

R
rahuldon1
February 28, 2024

Ex : REC_CREATED_DATE is "26/02/2024 13:00:23"
This formula will give date of "27/02/2024" only

Terms & ConditionsAccessibility statement

Loading footer...