/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


KBOX Service Desk Reporting - Add a column for date of report

02/14/2015 1305 views

I have been asked to add a "Date of report" column to the nightly service desk reports.  I realize that the date of the report is listed at the top of the report but for some reason my boss wants the date on every line of the report.

So my report would have the ticket number, time opened, Title, and then "Date of report" which would be the same date all the way down the column.  Seems like it should be easy just to insert the current date when the report is run but I have no idea how to do it.

Thanks in advance

Answer Summary:
0 Comments   [ + ] Show comments

Comments


All Answers

0
You could just add the Now() function to your report that would place the exact time and date on every line. Example:-

SELECT NOW() AS REPORT_DATE, HD_TICKET.ID, etc...

Or CURDATE() will just put the Date in CURTIME() for the just the time

Answered 02/16/2015 by: Druis
Third Degree Green 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

View more:

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