Querying custom date fields and performing calculations

Josh Johnston December 20, 2013

I have two custom date fields RecDAte and LiveDate and I'm trying to perform a search like this:

(RecDate / LiveDate) > 1

And I have no clear idea on how to approach this.

My first issue is that I can't seem to get a date value out of the custom fields in a format that I would expect, and then, I can't run the calculations at runtime. Help?

Thanks.

1 answer

0 votes
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 20, 2013

Just a hint: JIRA stores date values in milliseconds since 01/01/1970

Suggest an answer

Log in or Sign up to answer