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

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")