Requesting "Today" functionality in formulas; Want to Calculate Ageing; The formula I want to use is: Today(Date) - Creation(Date)

How to get Current Day date in a field to calculate ageing?

9 Likes

Welcome, @anon39323229,

That’s not possible today, but in the recent announcement of basic formula custom field is a mention of additional functionality coming, and another post in that thread asks for the same “today” calc ability, so we’re hopeful…

Thanks,

Larry

Do you know if there have been any updates to this question? I keep seeing posts about the “improved power” of formulas, but… I’m not seeing it in practice anywhere.

Really would like to see this!

Hi, @anon39323229
I would appreciate it if you could kindly submit this inquiry to “Product Feedback - Asana Forum”.
Thank you kindly.

I’ve modified the title and moved this thread to Product Feedback so you can vote at the top now.

Thanks,

Larry

Hi, I am looking for a way to count the number of days since an inputted date. Had a look into the advanced formula section and can see things like ‘DateAdd’ and ‘DateSubtract’ but nothing along the lines of ‘Current Date’, ‘Today’ etc.

Anyone know a solution to this?

2 Likes

Welcome, @John_Canning,

Formula fields are new and new features have been promised, and it’s hoped we’ll see this soon.

I’ve merged your post into an existing thread where you can click the title to scroll to the top and vote by clicking the purple Vote button.

Thanks,

Larry

1 Like

I am working with a client who is trying to use custom fields and formulas to calculate aging. Any updates on when this may be a possible function would be incredible.

2 Likes

Welcome, @Mitchell_Schwartz,

This is expected; see this new thread into which I merged your post for more info.

Thanks,

Larry

“expected” is a bit overly optimistic…

Here’s how to calculate your age.
Is this helpful?

Good news everyone! Happy to let you know that the TODAY function is gradually rolling out!

4 Likes