How can I convert a UTC timestamp from Google Sheets to UTC+7 for Jira tickets?

Below is one approach using plain JavaScript. Since your timestamp string already includes the "UTC" designation, you can create a Date object and then add 7 hours to convert it to UTC+7. For example:

JAVASCRIPTCopied
// Assume $json["Timestamp"] is "Jan 10, 2025 4:36am UTC"
const timestamp = $json["Timestamp"];
const dateUtc = new Date(timestamp);

// Convert to UTC+7 by adding 7 hours
dateUtc.setHours(dateUtc.getHours() + 7);

// Optionally, format the date into a string for display:
const options = { 
  year: "numeric", month: "short", day: "numeric",
  hour: "2-digit", minute: "2-digit", timeZone: "UTC"
};
const formattedDate = dateUtc.toLocaleString("en-US", options);

console.log(formattedDate);

Explanation

1. Parsing the Timestamp:
   The string "Jan 10, 2025 4:36am UTC" is parsed correctly by the Date constructor since it includes the UTC designation.

2. Adding 7 Hours:
   By using setHours(getHours() + 7), we adjust the time to reflect UTC+7.

3. Formatting the Output:
   The toLocaleString method is used to format the date. You can customize the options as needed for your Jira ticket display.

This snippet should work in your workflow to convert and display the timestamp in UTC+7. Feel free to adjust the formatting options to match your desired output format.