Find the Monday date of the week issue created/Done

[Myles Boyd]

Due to reporting limitations, I need fields to hold the Monday of the week the issue was created and another for when the issue is set to Done.

When I googled, I found something about using the Jira smart value  dayofWeek()  BUT that doesn't appear to be a JSM value, in fact {{issue.created.withDayOfWeek(1)}} returns blank.

Is there an easy way to calculate the Monday date from created/now ?

Thank you

[Christos Markoulatos]

Hi @Myles Boyd 

For "WithDayOfWeek(1) returns blank" is a known bug

[AUTO-1893] .withDayOfWeek Automation smart value not working - Create and track feature requests for Atlassian products.

try :

{{ issue.created.withNextDayOfWeek("MON").minusWeeks(1).format("yyyy-MM-dd") }}

Hope this helps !

[Myles Boyd]

You're a star - thank you.

[Christos Markoulatos]

Glad to hear it worked for u Myles. If u are happy with the answer please accept it as a solution as it helps us alot here in the community.

Glad to have u here!