Date Field Condition Between Today and Next 7 Days

kailashthiyagar
Kilo Guru

I m looking to set filter condition for a date field in my Report source. The condition is between today and next 7 days.

When i look at the options i have next week and not next 7 days.. Also when i use relative, i can set at or aft 7 days from now but that displays all the ones which are 7 days ahead. Any help on this would be great

1 ACCEPTED SOLUTION

kailashthiyagar
Kilo Guru

I got it working by implementing two conditions

 

First one Date --> After --> Today

Second one Date --> Relative ->on or before -> 7 days from now.

View solution in original post

1 REPLY 1

kailashthiyagar
Kilo Guru

I got it working by implementing two conditions

 

First one Date --> After --> Today

Second one Date --> Relative ->on or before -> 7 days from now.