Calculation to track age of request | Community
Skip to main content
S
SDowney
Level 2
July 11, 2025
Solved

Calculation to track age of request

  • July 11, 2025
  • 1 reply
  • 279 views

Hello!

I have created a custom request form and I need to track the age of the request to determine how long the request has been open. I want the start of my clock to be from a date entered in a specific field on the form to the current date or today's date. This calcuation will continue to change so was trying to use a wildcard but can't seem to find the right calculation formula. Does anyone have a calculation they have written or guidance on how to create this calcuation so I can calculate the age of my request from a specific date field to the current date?  Thank you for any help or guidance! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by JustinRenteria2

I personally would not put a field like this on a custom form due to the fact that the form and fields will have to be recalculated every day in order for the age to be accurate.  

What I do recommend is creating a report and adding a calculated column that contains this calculation.  Since report calculated columns are generated in real time, the age will always be accurate. The only downside I can really think of is that you will not be able to sort on this calculated column.

The calculation would look a little something like this:
valueexpression=WEEKDAYDIFF({DE:Your Date Field}, $$TODAY)     This will give you the count of weekdays between the two dates
or
valueexpression=DATEDIFF({DE:Your Date Field}, $$TODAY)     This will give you the count of total days (including weekends) between the two dates. 

Here's some documentation to help:  
Calculated custom fields vs. calculated columns | Adobe Workfront
View: Calculate Time and Date Differences | Adobe Workfront

1 reply

JustinRenteria2
JustinRenteria2Accepted solution
Level 6
July 11, 2025

I personally would not put a field like this on a custom form due to the fact that the form and fields will have to be recalculated every day in order for the age to be accurate.  

What I do recommend is creating a report and adding a calculated column that contains this calculation.  Since report calculated columns are generated in real time, the age will always be accurate. The only downside I can really think of is that you will not be able to sort on this calculated column.

The calculation would look a little something like this:
valueexpression=WEEKDAYDIFF({DE:Your Date Field}, $$TODAY)     This will give you the count of weekdays between the two dates
or
valueexpression=DATEDIFF({DE:Your Date Field}, $$TODAY)     This will give you the count of total days (including weekends) between the two dates. 

Here's some documentation to help:  
Calculated custom fields vs. calculated columns | Adobe Workfront
View: Calculate Time and Date Differences | Adobe Workfront

    Terms & ConditionsAccessibility statement

    Loading footer...