Issue Summary

When we use Automation to copy date attribute value from one asset object to another object, Incorrect date is getting updated.

• Source Object has Date attribute value 23/Nov/2024 > Then Automation updates Second Object Date value as 23/Sep/2024
• Source Object has Date attribute value 24/Nov/2024 > Then Automation updates Second Object Date value as 24/June/2024

Here

• If the source object Date attribute has any date that is Saturday > Then it gets updated as September in target.
• If the source object Date attribute has any date that is Sunday > Then it gets updated as June in target.

Steps to Reproduce

1. In Object Type create a Date Attribute.
2. Create 2 objects. In first object , add the date that points to Saturday
3. Create 2 Assets Custom Field which points to same Object Type.
4. Create a Jira ticket , in first custom field select First object which has Date attribute value. In Second custom field, select the second object which does not have date value.
5. Create Automation to copy date attribute from first object to second object custom field.
6. Observe the date is incorrect in Assets.It updated as September.
7. Now change the date in First Object to Point to Sunday. Run the automation again.
8. We will see the Date value in second object as June.

(OR)

1. In Object Type create a Date Attribute.
2. Create 2 objects. In first object , add the date that points to Saturday
3. In Automation, Add Branch on AQL > Enter AQL to select second Object.
4. Add Lookup Objects to query first object.
5. Use Edit Object > lookupObjects.Date.
6. Observe the date is incorrect in Assets.It updated as September.
7. Now change the date in First Object to Point to Sunday. Run the automation again.
8. We will see the Date value in second object as June.

Expected Results

Date value should be updated as same as the First Object.

Actual Results

Incorrect Date Value is updated in Asset Object.

• If the source object Date attribute has any date that is Saturday > Then it gets updated as September in target object
• If the source object Date attribute has any date that is Sunday > Then it gets updated as June in target object

Workaround

Instead of lookupObjects.Date or Issue.Customfield_XXXX.Date , add .jqlDate at the end and it will update correct date.

{{lookupObjects.Date.jqlDate}} 

OR

{{issue.customfield_ID.Date.jqlDate}}