How to fetch between from 9 days to 15 days data from from broad log table (only 7 days data from 9 days before 14 days after.)

Dear community,

I am unable to fetch the data between days. I need the data from current date before 9 days and 14 days.

For example: Workflow is running today (28-09-2024) but I need the data between from 14 days to 9 days (form 14-09-2024 to 19-09-2024)

Regards

Satya

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 ParthaSarathy

Hi @chandanasa ,

Try out the below condition,

DateOnly(@eventDate) on or after DateOnly(DaysAgo(14))

AND

DateOnly(@eventDate) on or before DateOnly(DaysAgo(9))

Current date is 30/9/2024. So the above condition will fetch records from 16/09/2024 00:00:00 to 21/09/2024 23:59:59

Accepted solution

Community Advisor

Try out the below condition,

DateOnly(@eventDate) on or after DateOnly(DaysAgo(14))

AND

DateOnly(@eventDate) on or before DateOnly(DaysAgo(9))

Current date is 30/9/2024. So the above condition will fetch records from 16/09/2024 00:00:00 to 21/09/2024 23:59:59

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Sign up