How do I configure a report to show the age of an asset based upon a date field?
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
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.
