JQL filter Issue for Change Start Date

[Neeraj Sharma]

Hi Team , 

I want to filter only data which is going to start in exact 48 hours from todays date. I am using two below query but its not working. 

"Change Start Date" = startOfDay(-2d)

 "Change Start Date" >= startOfDay(-2d) AND "Change Start Date" <= startOfDay()

how  can I filter data which is going to start in exact next 48 hours? like if I run query now(11/3), then it should filter the data of 13/3 only which is not happening. 

[Max Foerster - K15t · Accepted solution]

Hi @Neeraj Sharma ,

if you want to see a date in the future why do you subtract 2 days from it? Try this query for example

"Change Start Date" <= startOfDay("+2") AND "Change Start Date" > endOfDay("+1")

Best, Max 

[Radek Dostál]

Also I'd add the ' don't use equals(=) with dates '. Imagine dates as timestamps or milliseconds, if a Date is stored as 22-March-2022 23:59, you probably don't want exactly 23:59. Always use > < or >= <= with dates.

As per https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields#Advancedsearchingfieldsreference-CreatedCreatedDatecreatedDateCreated about 'created' - and I think this applies to Date/Datetime picker custom fields as well:

Search for issues that were created on, before, or after a particular date (or date range). Note that if a time-component is not specified, midnight will be assumed.