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

[rvnth]

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.

[rahuldon1]

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

[rvnth]

Hi @rahuldon1 ,

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

Please suggest

[rahuldon1]

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

[rvnth]

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

[rahuldon1]

Please add "TO_DATE" function to "eventdate" also.

To_Date(@eventDate)

[LakshmiPravallika · Accepted solution]

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.