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

This widget could not be displayed.
  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
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

143 views 1 3
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