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

Smart value to set Date/Time for 5pm same day

Kate

Help with Automation Smart values please?

I have created an automation that calculates a due date/time field based on when the ticket is lodged. This smart value works perfectly:

{{issue.customfield_1003.plusBusinessDays(5)}}

The team have now asked if a certain field is selected, can the due date auto calculate to 5pm that same day (aka end of that business day). Does anyone know a smart value that would allow for this?

Accepted answers

Darryl Lee

Hi @Kate -

It's kind of a weird syntax, but playing around with "To date with time conversion" I came up with this:

 {{now.withHour(17).withMinute(0).withSecond(0)}}

Which returned:

2023-07-04T17:00:00.0+0000

Which hrm, that's 5PM tomorrow, since it's not my time zone.

So I then added my time zone:

{{now.convertToTimeZone("America/Los_Angeles").withHour(17).withMinute(0).withSecond(0)}}

There we go:

2023-07-03T17:00:00.9-0700

So yeah, that ought to work.

All comments

Darryl Lee

Hi @Kate -

It's kind of a weird syntax, but playing around with "To date with time conversion" I came up with this:

 {{now.withHour(17).withMinute(0).withSecond(0)}}

Which returned:

2023-07-04T17:00:00.0+0000

Which hrm, that's 5PM tomorrow, since it's not my time zone.

So I then added my time zone:

{{now.convertToTimeZone("America/Los_Angeles").withHour(17).withMinute(0).withSecond(0)}}

There we go:

2023-07-03T17:00:00.9-0700

So yeah, that ought to work.

Darryl Lee

Caveat, it's 7:54PM in my time zone, so things might get a little trickier if say, at 5:01PM, you wanted the date to be the next business day at 5PM.

You could probably do some conditional logic and use the isAfter function. Maybe in conjunction with toDateTimeAtStartOfDay.

Darryl Lee

Why oh why doesn't Automation have an ELSE operator? I ended up having to have back-to-back IFs to get this to work:

{{#if(now.convertToTimeZone("America/Los_Angeles").isBefore(now.convertToTimeZone("America/Los_Angeles").withHour(17).withMinute(0).withSecond(0)))}}{{now.convertToTimeZone("America/Los_Angeles").withHour(17).withMinute(0).withSecond(0)}}{{/}}{{#if(now.convertToTimeZone("America/Los_Angeles").isAfter(now.convertToTimeZone("America/Los_Angeles").withHour(17).withMinute(0).withSecond(0)))}}{{now.plusDays(1).convertToTimeZone("America/Los_Angeles").withHour(17).withMinute(0).withSecond(0)}}{{/}}

Caveat: If somebody somehow sets that field at EXACTLY 17:00:00.0... I'm not sure what will happen. :-}

Kate

Thanks Darryl! I tried using this option:

{{now.withHour(17).withMinute(0).withSecond(0)}}

and its defaulting for the next day for me as well! I'm located in NZ, so I don't think it's a timezone issue, but it's definitely a head scratcher. This is a great starting point though!

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