offset date picker/date time picker in email notifications

we have couple of date pickers and date time pickers. I have 2 issues with these fields

  1. Date and time are not absolute values, instead displays as xx minutes ago. would like to see real created/updated date time
  2. Date times values in emails appears to be shown in the GMT time zone.would like to see Eastern time zone when dates are in email notifications

Default user time zone is set to (GMT-05:00) New York

Custom email notification uses $issue.getCustomFieldValue("customfield_xxxx") to get customfield values.

JIRA Version 6.4.3

Your help is appreciated...

 

1 answer

0 vote
  1. See https://confluence.atlassian.com/display/JIRAKB/Disable+relative+dates+in+JIRA+applications
  2. You've got a time zone problem on the server (probably).  You can test this by forcing the  correct timezone for the java virtual machine in the setenv.sh/setenv.bat file (from memory, -Duser.timezone= )
  1. works after setting jira.lf.date.relativize=false
  2. If i edit date/time field of an issue -> "Issue Updated" event generates email and has correct local timezone(EST) in email as well. If i perform/take action on an issue -> custom event generates email and has wrong time zone for dates. Following is used inside email templates to get the value

$issue.getCustomFieldValue("customfield_xxxx")

Is data stored in as GMT in database?

Please assist on how can i get local timezone in email notifications

 

FYI...Issue is resolved

"customfield_xxxxx is a date/time picker", JIRA somehow converts time to GMT(probably that is what persisted in database as GMT) and sends out email notifications.

dateformatter does converts date/time to use local timezone and displays date in local timezone.

$dateformatter.format($issue.getCustomFieldValue("customfield_xxxxx")),

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted 9 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

33 views 0 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you