/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

Answers

3
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

Please log in to comment