Ticket Log DateTime only showing Date

V5 Issue
1

I just implement Ticket Logs on v5.1.62 based on the Creating Ticket Logs to Improve Security Tutorial, however the Date Time column only shows the date.

image.png1920×1017 77.4 KB

I get the same on reports that use {REPORT TICKET LOG DETAILS:X}

image.png1008×729 42.4 KB

Date is being stored in the database as a C# Ticks value I believe:

image.png938×131 4.12 KB

Any ideas? @emre

2

Try using L.LogDate and L.LogTime fields for REPORT TICKET LOG DETAILS.

3

Yeah that works on the report.

But how about on the Display Ticket Log screen? I need it to work there mainly.

In your tutorial, it was showing date and time.

4

On a side note, what is the report syntax to use if I want to join the L.LogDate and L.LogTime fields in one column? I tried [L.LogDate]+[L.LogTime], [L.LogDate]+' '+[L.LogTime], [L.LogDate] & ' ' & [L.LogTime] but I think I am missing something? I’m sure I saw a report on the forum before joining 2 strings in one column but can’t find it.

[Cancelled Orders:1,2,2,4]
>Ticket No|Date|User|Details
{REPORT TICKET LOG DETAILS:L.TicketNo,L.DateTime,L.UserName,L.Log:L.Category = "Order Cancelled"}
5

@emre can I check did you fix this in 5.2.1 beta? I downloaded that on another machine and notice the date time is displaying correctly on that system. Just want to double check you did fix it or if it might have been something related to my setup on the first machine, as if fixed I will need to update 6 terminals at client site to 5.2.1 so they can use ticket log. Thanks.

6

Displaying time added on 5.2.1

1 Like