Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Calculating difference between two date custom fields in Trello

I am looking if there is a way to calculate the difference between two date custom fields using Butler? Ex: I have 'Start Date' and 'Completion Date' as 2 custom fields and if I want to know the duration of the task, want to write a Butler rule which will calculate the difference of these 2 dates and return in another custom field of 'Task time'. Can someone help?

1 answer

0 votes
Vero Rivas Community Leader Apr 29, 2021

Hi @Manjula Madineedi 

   Look at this post, maybe can help you

   https://help.trello.com/article/1159-arithmetic-in-date-variables

Cheers

   

Thanks for sharing @Vero Rivas . But that doesn't work for me. Here is the rule I wrote:

when a card is moved into list "Completed", set custom field "* Hours Task Time" to "{{%Completion Date}-{%In Progress Start}}"

When I checked the Command log of the rule, it had this message -- "NaN" is not a valid numeric value.

I am not sure what's wrong in the above rule..

I'd like to know the answer to this as well. I have the same custom field set up with start date. Trello seems to have updated the calendar to allow start and end dates. That's the only way I've been able to get the timeframe between start and end. 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristjan Geir Mathiesen - Origo for sharing the picture of Taco having fun with his new friend...

538 views 19 20
Join discussion

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