Create a filter based on date field

[Bar Abergel]

Hey guys! 

I've created a custom field of date which I use in order to have the onboarding/off boarding date of employees. 

I would like to have a query which shows me all issues that their on boarding date field (for example) is set for next week. This query should always look for issues which their onboarding date is in 7 days from {{now}}.

How can this be done? 

[Mikael Sandberg · Accepted solution]

You can use the endOfWeek() and startOfWeek functions to do this. This one should do it:

custom_date_field > startOfWeek("+1") AND custom_date_field < endOfWeek("+1")

[Bar Abergel]

Thank you so much! it works like a charm :)