10/30/2017 973 views
We have date field we call "purchase date" and I'd like to create a report to show the age of the asset based upon that field. Is this something I can do in the asset itself or tweak a report to show that.
0 Comments   [ + ] Show comments


All Answers

Yes, this should be possible. You are going to want to read the documentation on Date Time functions:
MySQL documents can also be helpful and where I normally check first:

Specifically, you will want to calculate the date difference (using datediff) and then format the result using date_format.
Answered 10/31/2017 by: chucksteel
Red Belt