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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

102 views 0 2
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