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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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
Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share