Pull the report which custom_date is at or after 7 days from now

vardhini
Kilo Expert

HI Team,

I want to pull the data which I have field 'third notification date'. 

The condition is the 'Third notification date is on or after 7 days from now'.

vardhini_0-1717137450609.png

 

How to filter this condition kindly provide your suggestion.

 

Regards,

Vardhini

3 REPLIES 3

Mark Manders
Tera Patron

Your screenshot shows exactly that condition. What is your question?

Hi Mark,

Thanks for your reply.

If I use the above condition It returning empty records.

But I have a data as shown in the below screenshot which Third Notification Sent Date is greater than 7 days from now.

vardhini_0-1717138073244.png

What is the exact condition I need to place to fetch 'Third Notification Sent Date is on or after 7 days'.

 

Regards,

Vardhini

Mark Manders
Tera Patron

The 23rd of May was over a week ago, so that should never return when you try to find records with a date of 7 days from now, right?