Hi,
I'm looking for a way to identify the number of days between card creation and the due date complete. I'd like to put this in an email report which I already have automated.
I've gotten as far as setting a custom field to set the date to "now" when a card is completed, but I can't seem to make any math of it and the creation date.
Am I missing something here? Do I need to convert the dates to numbers? and if so, could someone please help me with that part as well :)
Thanks
See the section on card times : https://support.atlassian.com/trello/docs/butler-variables/
Thanks @milynnus , however, I still have the issue of capturing that number without it updating.
For example, a card was created on 1/1/2022 and the due date was checked (and therefore completed) on 2/1/2022. How can I measure the time between those 2 dates expressed in days?
I've tried subtracting the creation date from a custom field that marks the date to "now" when the due date is checked off:
{{%Project Complete Date}} - {{cardcreationdate}}
But that doesn't work.
Alternatively, I've tried setting that custom field to {cardagedays}, but I'm concerned about that value increasing over time.
How can I capture that number and stop it from counting once the card is completed?
Thanks again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This will work when you save the days to a custom field when card is marked completed. While the age will continue to increase, the value you save it the CF will remain unchanged.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.