/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chucksteel 6 years ago
Red Belt
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.

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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ