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.)

[chandanasa]

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

[ParthaSarathy · Accepted solution]

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