nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why do quotes around dates in this query need to be removed to work?

unknown

(created <= startOfWeek(“-5d”) AND created >= startOfWeek(“-6d”)) OR (created <= startOfWeek(“-12d”) AND created >= startOfWeek(“-13d”)) OR (created <= startOfWeek(“-19d”) AND created >= startOfWeek(“-20d”))

This fails with the following error message.

Duration for function 'startOfWeek' should have the format (+/-)n(yMwdm), e.g -1M for 1 month earlier.

The following query without quotations returns the expected issues.

(created <= startOfWeek(-5d) AND created >= startOfWeek(-6d)) OR (created <= startOfWeek(-12d) AND created >= startOfWeek(-13d)) OR (created <= startOfWeek(-19d) AND created >= startOfWeek(-20d))

Accepted answers

Rob Horan

I believe its because that's a syntax requirement.

All comments

Rob Horan

I believe its because that's a syntax requirement.

unknown

Yes, I thought the quotes were a syntax requirement.

This is a sample form an Atlassian blog post https://www.atlassian.com/blog/jira-software/jql-secrets-and-shortcuts

I tried it but it did not work until I removed the quotes.

I am searching for some documentation relating to this...

unknown

(created <= startOfWeek(“-5d”) AND created >= startOfWeek(“-6d”)) OR (created <= startOfWeek(“-12d”) AND created >= startOfWeek(“-13d”)) OR (created <= startOfWeek(“-19d”) AND created >= startOfWeek(“-20d”))

When I enter the above query Jira returns:

"Duration for function 'startOfWeek' should have the format (+/-)n(yMwdm), e.g -1M for 1 month earlier."

When the query is entered without the double quotes it returns the expected results.

(created <= startOfWeek(-5d) AND created >= startOfWeek(-6d)) OR (created <= startOfWeek(-12d) AND created >= startOfWeek(-13d)) OR (created <= startOfWeek(-19d) AND created >= startOfWeek(-20d))

I have not found an explanation for this behaviour. Are there any JQL experts who understand this?

Rob Horan

I got the same error with your statement but no error when I removed all quotes.

(created <= startOfWeek(-5d) AND created >= startOfWeek(-6d)) OR (created <= startOfWeek(-12d) AND created >= startOfWeek(-13d)) OR (created <= startOfWeek(-19d) AND created >= startOfWeek(-20d))

I got no results, but that's because of what's on my instance

EDIT - and that's what you originally wrote.

Apologies, its been a long monday and I could use a pint...

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud