/build/static/layout/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   [ + ] Show comments

Comments


All 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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share