Notification

Icon
Error

Show Date Without Time - Configure date column to show only the date without time

Posted: Tuesday, May 4, 2021 10:39:43 PM(UTC)
nhouse24

nhouse24

Member Original PosterPosts: 6
1
Like
Hello,

I am hoping to get some help with this report. I'd like the Creation Date and Last Update Date to show as DD/MM/YYYY WITHOUT showing the time.

SELECT TOP (1000000) '#' + CAST(htblticket.ticketid AS nvarchar) AS Ticket, htblticket.date AS CreationDate, htblticket.updated AS LastUpdated, htblticketstates.statename AS State, htblpriorities.name AS Priority,
htblsource.name AS Source, htblusers.name AS [User], htblusers2.name AS UserLastNote, htblticket.subject AS Subject
FROM htblticket INNER JOIN
htblpriorities ON htblpriorities.priority = htblticket.priority INNER JOIN
htblticketstates ON htblticketstates.ticketstateid = htblticket.ticketstateid INNER JOIN
htblusers ON htblusers.userid = htblticket.fromuserid LEFT OUTER JOIN
htblagents ON htblagents.agentid = htblticket.agentid LEFT OUTER JOIN
htblusers AS htblusers1 ON htblusers1.userid = htblagents.userid INNER JOIN
htbltickettypes ON htblticket.tickettypeid = htbltickettypes.tickettypeid INNER JOIN
htblsource ON htblticket.sourceid = htblsource.sourceid INNER JOIN
htblusers AS htblusers2 ON htblticket.userid_lastnote = htblusers2.userid
WHERE (htblticket.date > GETDATE() - 7) AND (htbltickettypes.typename = N'Change Management') AND (htblticket.spam <> 'True')
ORDER BY htblticket.ticketid

Active Discussions

Lansweeper Report showing only Wi-Fi Devices and MAC addresses
by  Andy.S   Go to last post Go to first unread
Last post: Today at 2:23:24 PM(UTC)
Lansweeper Modifying Purchase Date / Yearly Refresh Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 5/7/2021 7:06:47 PM(UTC)
Lansweeper Tweak LanSweepers Bios Version Audit to show Last Seen
by  Tyler M.  
Go to last post Go to first unread
Last post: 5/6/2021 8:22:40 PM(UTC)
Lansweeper Patch Volume Across Fleet
by  darren.kimber  
Go to last post Go to first unread
Last post: 5/5/2021 11:29:33 PM(UTC)
Lansweeper Show Date Without Time
by  nhouse24   Go to last post Go to first unread
Last post: 5/4/2021 10:39:43 PM(UTC)
Lansweeper Report of list of assets
by  Carlos Montes  
Go to last post Go to first unread
Last post: 5/4/2021 2:52:15 PM(UTC)