KBOX Service Desk Reporting - Add a column for date of report
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
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Druis
9 years ago
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
