Calculation to track age of request

[SDowney]

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! 

[JustinRenteria2 · Accepted solution]

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