Custom date filter for report - Last 15 days

Sironi
Kilo Sage

Hi All,
Like OOB Last 7-days , I want custom filter for 15days

Sironi_1-1721334599028.png

 


I m trying to get list of records which are not updated with in 15-days , exclude today.
active=true^sys_updated_onRELATIVELT@dayofweek@ahead@15^sys_updated_onRELATIVEGT@dayofweek@ago@15

Sironi_0-1721334490817.png

Expected result not populating kindly help me on it.


 

1 ACCEPTED SOLUTION

Bert_c1
Kilo Patron

Try the following:

 

Screenshot 2024-07-18 163802.png

 

Works for me.

View solution in original post

4 REPLIES 4

Bert_c1
Kilo Patron

Try the following:

 

Screenshot 2024-07-18 163802.png

 

Works for me.

Thanks for your reply, I tried your solution, it working for me.

AndersBGS
Tera Patron
Tera Patron

Hi @Sironi ,

 

Just utilize the simple condition as below:

AndersBGS_0-1721339109399.png

The reason that I have utilized 16 days instead of 15 days is because you would like to exclude today. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi , Thanks for your reply,

I 'm getting  last month records details also but I want within 15-days records list.