Structures: using "resolved"/"resolutiondate" in column formula not working

Question

I have a Jira structure that is returning Epic's under a certain condition which are extended to show issues belonging to Epics (Stories).

Via a formula column i am trying to sum the number of stories completed within a certain time period and sum that number at the Epic level;

IF issuetype = "Epic":

SUM{IF issuetype = "Story" AND (resolved>08/05/2024 ) : 1}

I have also tried

IF issuetype = "Epic":

SUM{IF issuetype = "Story" AND (resolutiondate>08/05/2024) : 1}

While completed stories are being totalled correctly that date is being ignored, is the date format i am using incorrect, is there a better way?......

Stepan Kholodov · Accepted Answer

Hello @Crads

The Formula column processes dates as timestamps, so a custom date should be defined as one as well. To define a date, you can use the date() function like this:

if resolved > date("2024-05-08"): 1

I hope this helps. If you need further assistance or if you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)