Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Has anyone done a calculated field that shows a date difference between planned completion date and a custom date?

Avatar

Level 3

I have a Target Launch Date custom field and I would like to see the date difference between that date and the Planned Completion on the project.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Brittany,

There are a couple of different ways to achieve this depending on what your requirements are.

(1) You can create a new custom field on your project custom form that will work out the difference between the two dates so that you can then reference it in reports and visualise the data in graphs / charts. To achieve this you would simply add a calculated field to your project custom form and add the calculation: WEEKDAYDIFF(Planned Completion Date,Target Launch Date).

(2) You can add a column to an existing project report, switch it to text mode and add the following code. This will add a new column to your report view which will display the difference between the two dates. You wont be able to use this in graphs or charts and it will only work on the report where you have added this custom column

displayname=Date Difference

textmode=true

valueexpression=WEEKDAYDIFF({plannedCompletionDate},{DE:Target Launch Date})

valueformat=HTML

Hope this helps! Please shout if you have any questions.

Best Regards,

Rich.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi Brittany,

There are a couple of different ways to achieve this depending on what your requirements are.

(1) You can create a new custom field on your project custom form that will work out the difference between the two dates so that you can then reference it in reports and visualise the data in graphs / charts. To achieve this you would simply add a calculated field to your project custom form and add the calculation: WEEKDAYDIFF(Planned Completion Date,Target Launch Date).

(2) You can add a column to an existing project report, switch it to text mode and add the following code. This will add a new column to your report view which will display the difference between the two dates. You wont be able to use this in graphs or charts and it will only work on the report where you have added this custom column

displayname=Date Difference

textmode=true

valueexpression=WEEKDAYDIFF({plannedCompletionDate},{DE:Target Launch Date})

valueformat=HTML

Hope this helps! Please shout if you have any questions.

Best Regards,

Rich.