I have a Custom field called "StartMaintenanceTime" which allows users to select a date and time in the format of MediumDateTime. My end goal is to have this add the incidents on my Project's calendar. The Calendar itself uses the fields "StartDate" and "DueDate" to populate.
My initial solution was to create an automation that copies the value from "StartMaintenanceTime" to the "StartDate" and "DueDate" fields.
This solution works most times however I've found that in some cases the "StartDate" and "DueDate" values copied from "MaintenanceStartTime" are incorrect. Here is an example from one of my incidents that this occurs.
I believe the issue is that Jira has trouble Copying a date that is in the mediumDateTime format to a field that is just mediumDate. My initial thought is that I could save a variable such as {{MaintenanceStartTime.mediumDate}} and then copy that variable to the "StartDate" and "DueDate" fields but I believe I may be doing that incorrectly.
I created a variable labeled {{MaintStart}} using the value {{MaintenanceStartTime.mediumDate}}. This however returns a value of none.
update 9/11/24 : I am still working on a resolution. In one case I see the field for Maintenance Start time set as Sep 16, 2024, 9:30 PM. The automation runs that and it copies this field to the Start Date field. The result is Sep 17, 2024 which is incorrect.
I've tried to SET the field to {{issue.Maintenance Start Time.mediumdate}} but that returns a value of "none".
Found the issue to be related to the Timezone users were submitting their changes in. I now have the start date being set with the following smart value to keep the dates accurate.
{{issue."Maintenance Start Time".convertToTimeZone("US/Eastern").jiraDate}}
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.