Subtract Dates

Dec 11, 2013 at 3:57 PM
Its possible to calculated amont of days between a date and today?

Aging = $NOW$ - Created Date

Dec 11, 2013 at 4:59 PM

You can do this using the @-7 function in the query but not in the aggregator

Jan 17, 2014 at 6:11 PM
Maybe a bit late to be replying to this post, but I have been trying to do the same thing. I realize there are the @-7, @-30 functions for work item queries, but is there a way to have a work item field which calculates the number of days between another date time field and today's date?

For example, a Sprint has a deployment date of 1/31/14. Can you create a Remaining Days field on the work item which would show the number of days (ideally work days) between today and the deployment date of 1/31 using Aggregator or any other means?