Querry on Table based on date

[JuliaWeis98]

Hi guys,

i want to add a module to my navigator. When i click on this module i want to see all knowledge articles within next 60 days.  Problem is, that in the filter dropdown is no "Next 60 days" available.

Can someone help me with this problem?

[M Iftikhar]

Hi @JuliaWeis98,

On the Valid To field you can just do:

That gives you all articles that expire within the next 60 days. I tested this filter in the list view and it worked as expected. You can then copy that filter  and drop it into your module definition.

Thanks & Regards,  
Muhammad Iftikhar  

If my response helped, please mark it as the accepted solution so others can benefit as well.