It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Find next date from multiple date fields

Within an Epic, we have 18 custom date picker fields to represent the launch date for each of our 18 markets. I want to have another custom field called, "Next Launch Date", where it looks at the 18 different market launch dates and returns the next chronological date from amongst the 18. On any given launch, some or all of the 18 markets will have a launch date. For those markets that will not launch, the field is empty. But there is at least ONE market launch date. As an example: 

If today is November 17, 2019 and I expect to launch in Market 1 on December 15, Market 2 on December 20, Market 3 on November 19 and Market 4 on November 29, then when I look at the proposed "Next launch Date", the date shown would be November 19 because (as of November 17) the next Launch date is Market 3 on November 19. When I look again on November 20, the date shown would be November 29. 

I've looked at calculated fields but cannot figure out how to proceed. Any guidance?  

0 answers

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you