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; } } }

Last Business Day

Melissa C

Help!

I thought this was going to be an easy one!

I run a report via automation on Monday morning, I want the date in the subject to be the Friday before date.

Now = February 5, 2024

{{now.toBusinessDayBackwards}} = 2024-02-05T15:11:25.7-0500

{{now.toBusinessDayBackwards.LongDate}} = February 5, 2024

The date should be February 2, 2024

Accepted answers

Bill Sheboy

Hi @Melissa C

I am using Jira Cloud, not Server, so please try this with your version:

It is clunky but works...subject to time zone stuff and when you run the rule.

Kind regards,
Bill

Kalyan Sattaluri_iinm1n

I believe its a known issue, please try {{now.minusBusinessDays(1)}}

https://community.atlassian.com/t5/Jira-Software-questions/Smart-value-issue-created-toBusinessDayBackwards-does-not-work/qaq-p/2490448

All comments

Bill Sheboy

Hi @Melissa C

I am using Jira Cloud, not Server, so please try this with your version:

It is clunky but works...subject to time zone stuff and when you run the rule.

Kind regards,
Bill

Kalyan Sattaluri_iinm1n

I believe its a known issue, please try {{now.minusBusinessDays(1)}}

https://community.atlassian.com/t5/Jira-Software-questions/Smart-value-issue-created-toBusinessDayBackwards-does-not-work/qaq-p/2490448

Melissa C

@Bill Sheboy @Kalyan Sattaluri

Almost! I got this

{{now.withNextDayOfWeek("FRI").minusDays(7)}} = 2024-02-02T16:04:17.5-0500

But I added "longDate" and that worked

{{now.withNextDayOfWeek("FRI").minusDays(7).longDate}} = February 2, 2024

@Kal

Thank you I added "longdate" and that worked
{{now.minusBusinessDays(1).longDate}} = February 2, 2024

Bill Sheboy

Well done!

All of those format modifiers return the date (or date / time) formatted as text. When you need to keep the value as a date (such as to set to another date field) leave the format off.

Melissa C

@Kal

Thank you I added "longdate" and that worked
{{now.minusBusinessDays(1).longDate}} = February 2, 2024

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-software-server