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