Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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)

 

chandanasa_0-1727513586130.png

 

Regards

Satya

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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