Created Date - Today's Date = How many days old

Question

Hi Team,

From a Jira export, we're trying to assimilate how many days old each ticket raised is.

We know hte created date, and assume using today's date we should be able to work out how many days have since passed.

Presume we use the DateTimeDiff formula but struggling with the rest.

Date format in the column is "04/12/2019"

Thanks

afv2688 · Accepted Answer

Hello @david-r ,

Would this work?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards