Querying custom date fields and performing calculations

Josh Johnston2

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.

Udo Brand

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