Determine if the current hour falls between two values from lookup tables

Richard A. Michaels

I have two lookup tables, one defines the start hour and the other defines the end hour.

I need to create a variable which will either be true or false based on whether the current hour is within the range.  I've tried the following smart value but Jira can't render the value

Based on the value of the variable, another value will be set to true or false.

Here's the smart value formula I'm trying to get to work.

{{and(now.convertToTimeZone("America/New_York").hour.gt(tblStartHour.get( varKey),now.convertToTimeZone("America/New_York").hour.lt(tblEndHour.get(varKey))}}

Has anyone done such a smart value calculation or have ideas to accomplish this.

Trudy P Claspill

Hello @Richard A_ Michaels 

I recommend that you use the Log action to log the values within the smart value piece by piece to verify you are getting the hours you expect. For instance in a Log action log

{{now.convertToTimeZone("America/New_York")}}

Then in the next Log action log

{{now.convertToTimeZone("America/New_York").hour}}

Then

{{varKey}}

{{tblStartHour.get( varKey)}}

{{tblEndHour.get(varKey)}}

 

One problem that I suspect this may identify is that I believe this is not valid syntax:

{{now.convertToTimeZone("America/New_York").hour}}

...since hour is not one of the format key words listed here:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

To extract the just the hour from the results on convertToTimeZone you would need to use the format command with a valid input as described here:

I think what you will need to use is one of these

now.convertToTimeZone("America/New_York").format("h") - to get the hour as 1-12

now.convertToTimeZone("America/New_York").format("k") - to get the hour as 1-24