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


Please log in to comment

Answer this question or Comment on this question for clarity


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