Solved

Planning - Date Difference calculation formula field

Forum|Forum|7 months ago
June 11, 2025
4 replies
915 views

Hi Community,

I have a question about a time difference calculation in Planning. I have a field called End Date and i want to calculate the weeks until this End Date in T-weeks.

I used this formula with the intend to receive the following results: T-6, T-4, T-0 etc., but for some reason the $$TODAY makes issues in the formula field for Planning, since I am either getting T-0 for all calculations/data variations or no results at all.

Any thoughts? Workarounds? Tipps?

I already tried the following calculations:

IF({Date End}>$$TODAY,
CONCAT("T-",ROUND(DATEDIFF($$TODAY,{Date End})/7)),
"T-0")

IF({Date End}>$$TODAY,

CONCAT("T-",ROUND(DATEDIFF($$TODAY,{Date End})/7)))

CONCAT("T-",ROUND((DATEDIFF($$TODAY,{Date End}))*-1/7))

DATEDIFF({Date End},$$TODAY)

ROUND(DATEDIFF({Date End},$$TODAY)/7)

CONCAT("T-",ABS(ROUND(DATEDIFF($$TODAY,{Date End})/7)))

WEEKDAYDIFF($$TODAY,{Date End})

Thank you for any thoughts in advance.

Best answer by skyehansen

Adding that I was able to get a bit of time in Planning just now, and it looks like $$NOW is displaying. Either using $$NOW, or CLEARTIME($$NOW) might be a good workaround until you figure out what's going on with $$TODAY

JustinRenteria2

Level 6

Haven't tested any of these calcs but the first thing that caught my eyes was that you're missing the "DE:" in your calculations. Every instance of the Date End field should appear as follows: {DE:Date End}

T

TraKillAuthor

No planning is not using the "DE:" at least not for the calculations i have done so far. But thanks for the thought!

skyehansen

Community Advisor

Still wondering if the field name is End Date or Date End.

T

TraKillAuthor

Sorry, you are absolutely right, that was confusion. It is "Date End".

skyehansen

Community Advisor

Taking a look at the Planning documentation, it doesn't say you cannot use wildcards. So I'd recommend you submit a case to Workfront Support or have your authorized contact submit a case. It can be as simple as this:

Take the simplest calculation you can, for example, CONCAT($$TODAY) is pretty foolproof and likely to produce a result, but instead it only displays the first part, and not the wildcard part. Then point out to support that it's not throwing an error, and that documentation doesn't indicate it shouldn't be used. Then, ask what the intended result should be.

skyehansen

Accepted solution

Community Advisor

Adding that I was able to get a bit of time in Planning just now, and it looks like $$NOW is displaying. Either using $$NOW, or CLEARTIME($$NOW) might be a good workaround until you figure out what's going on with $$TODAY

T

TraKillAuthor

Unfortunately after replacing $$TODAY with $$NOW the T-0 disappears as it did before for some of the examples. No results, just blank, but no error message for the formula. Same for CLEARTIME($$NOW)

kautuk_sahni

Community Manager

@trakill Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

Kautuk Sahni

T

TraKillAuthor

Hi @kautuk_sahni,

Yes the response helped me with the issue. Thanks for double checking.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded