Set a Calculated Date base on custom field date value

[Sonya S_]

we have one calculated datetime field based on another custom date field and the formula in below worked.

<!-- @@Formula:(issue.get("customfield_10805") == null ? null : issue.get("customfield_10805")) -->

<!-- @@ format: DATE  -->

However, the format is still datetime format (dd/MMM/YY hh:mm)

is there any way to make it display date only ?

If I add calculation function into it, it became invisible (doesn't work)

<!-- @@Formula:(issue.get("customfield_10805") == null ? null : issue.get("customfield_10805")-21) -->

<!-- @@ format: DATE  -->

can any suggest how I calculated the date based on another custom field ( A-21) ?

Thank you,

[David Fischer]

Hi Sonya,

regarding the date formatting, the marker is “@@Format:”, not “@@ format:”. So try:

<!-- @@Format: DATE -->

As for calculations on Date objects, you can’t use operators. You need to get the number of milliseconds of the date, add or substract the duration in milliseconds, and then create a new date from it:

new Date(issue.get(“customfield_10805”).getTime() - 21*24*60*60*1000)

[Sonya S_]

Hi David, 

thank you, however, it still doesn't work in my end. 

I've tried to use below setting, neither of them work >"<

<!-- @@Formula: (issue.get(“customfield_10805”).getTime() +5184000000) -->

<!-- @@Formula: 
new Date(issue.get(“customfield_10805”).getTime() - 21*24*60*60*1000)
-->

<!-- @@Formula: 
new Date(issue.get(“customfield_10805”).getTime() - 21*24*60*60)
-->

the only work in my end is , but still display in date time format

<!-- @@Formula:issue.get("customfield_10805") -->

<!-- @@ Format: DATE_PICKER -->

[David Fischer]

Hi Sonya,

regarding the formula, only the second one should work. Did you find any error in the Jira logfile (atlassian-jira.log)?

And regarding the format, there should be no space between @@ and Format - c.f. my example.

Regards,

David

[Sonya S_]

hi, David, 

for formula 2, it doesn't work. (for no reason >"<)

for format, it works after remove space, thank you :)

[David Fischer]

As I said, did you look for errors in the log file?