Hello, Can someone help with the following saved search formula : I would like to added a criteria based on a date field to show only lines between (from: today -1month To: Friday of the last week) Thanks in advance !

Probably will need 2 conditions. 1. Date is on or after same day last month 2. CASE WHEN TO_CHAR({today}, ‘D’) = 1 THEN {today} - {datefield} + 5 WHEN TO_CHAR({today}, ‘D’) = 2 THEN {today} - {datefield} + 4 WHEN TO_CHAR({today}, ‘D’) = 3 THEN {today} - {datefield} + 3 WHEN TO_CHAR({today}, ‘D’) = 4 THEN {today} - {datefield} + 2 WHEN TO_CHAR({today}, ‘D’) = 5 THEN {today} - {datefield} + 1 WHEN TO_CHAR({today}, ‘D’) = 6 THEN {today} - {datefield} WHEN TO_CHAR({today}, ‘D’) = 6 THEN {today} - {datefield} + 6 END is greater than or equal to 7 The first condition will validate if the date is within 1 month ago the second will validate what day of the week it is and then if the date is on or before last Friday

Hello @Al1, Thank you for your help which was very helpful!