Hi everyone, it’s my first week in the forum and please forgive the basic question…how do you create a field to calculate the number of days between a due date and today’s date? Thanks!

Hi everyone! Just to let you know that the TODAY function is gradually rolling out! [image] Formula custom field with Advanced Editor Product Updates Hey everyone, I’m excited to share more great news with you; a much-wanted feature is gradually rolling out for Advanced F…

Hi @anon93796111 , welcome to the forum :wave: This is currently not available on the task level. You can enable the Time remaining field in Portfolios (available for Business and Enterprise plans). This field will show you the time remaining until the project’s end date from today (as long as the …

I enabled this field and noticed that it says “1 week” for a project due Oct 31st. Does it not calculcate on days? (ex 1 week, 2 days)?

Hi @Chantelle_Drury , I take it you are referring to the ‘Time remaining’ field in Portfolios which I mentioned above. Once your project is due less than a week, the native ‘Time remaining’ field will display 6 days, 5 days, etc. Unfortunately, currently, this native field cannot be formatted to ho…

Yes that is the field I’m referring to, thank you. The time remaining field doesn’t seem to be calculating correctly: I’m not understanding why the column field says “No data”, and why the projects with a due date of Oct 31 just say “1 week”, which isn’t correct. [image]

Hi @Chantelle_Drury , I’ve been able to recreate what you are seeing. There seems to be some bug or unexpected behaviour when changing the due date, specifically when removing the start date and re-inputting it, which gives the ‘No data’ value. I managed to overcome this by clearing the Date field …

Thanks Richard! I was able to correct all of them but the Items with the Oct 31 due dates. Is it not possible to be more accurate than just 1 week? This is less than 2 weeks, so I would think it would show 1 week, xx days. Is that not how it works? Thanks again. [image]

@Chantelle_Drury , I understand your frustration. It would be ideal if the value was more granular such as in weeks AND days left. You can actually achieve a more accurate value for the duration of the project because that is based on start and end date of the project which are already available as …

@Chantelle_Drury and @Richard_Sather , Please vote for my old request here: [image] Portfolio Duration and Time Remaining Deficiencies Product Feedback How Duration is calculated/displayed doesn’t make sense to me. See these two examples: [image] [image] Perhaps after …

Thanks @lpb , I remember this one!

Hi Richard. Is there any way to know when our account might get the today function if it doesn’t already have it?

Is there a Today field?

English Forum Ask the Community

Richard_Sather 28 February 2024 12:26 13

Hi everyone! Just to let you know that the TODAY function is gradually rolling out!

Topic		Replies	Views
:calendar: How you can use the Today input in Advanced Formulas, today! Forum Leader tips forum-leader-tip	27	4317	18 July 2025
New Column: Overdue in Days Features Launched	7	601	28 February 2024
Measuring & reporting age of tasks Ask the Community tasks	6	1302	22 March 2024
数式機能で、「今日」の日付を計算に使用できるようにしてほしい製品フィードバック	3	1042	7 March 2024
Requesting "Today" functionality in formulas; Want to Calculate Ageing; The formula I want to use is: Today(Date) - Creation(Date) Features Launched launched	12	2547	28 February 2024

Is there a Today field?

Related topics