Search the Community
Showing results for tags 'time and date'.
Hi All, I have a couple of conundrums that I wonder whether any one has come across themselves/resolved? Date/Time Sorting We have a case which has chat message data held within it; SMS, WhatsApp, iMessage etc... Our customers have been asking for reports of custodian messages in a threaded format (with the conversations sorted by date and time). I can create the report, using the "Report" function on the "Export Type Selection" screen. When I get to the sections, I can select the "Communication" section, displaying the items as a conversation, sorted by Primary Date (see image). However, when I export the report, I notice that the conversations are not sorted into Date/Time order. As you will see on the attached PDF file (which has been sanitised for privacy), you will see that there are a couple of conversations in the correct date/time order, but then a thread of chat messages from October appears. Following that, you will see further instances of out-of-order chat threads. I have tried using the section for "Chat Conversations", but that just returns a blank report with no items within it. I expect that this is because all the items we are exporting are of type "Chat Message" only, but as it threads them into a "conversation" in the report, I expected it to be able to sort the threads by date/time order? Date/Time Conundrum Another quirk I have noticed when exporting is, within the report output there is a table that provides the GMT/BST date/time at which the threaded conversation occurs, but within the data in the table below this, it is in the native date/time format (of Eastern Time as these are from US devices). Is there a reason why one part of the table exports in GMT/BST time and the data in the native time zone of the items in the database? Also, is there a way to configure the export to use one or the other time zone? Thanks in advance JT Unsorted Threaded Chat Message Report.pdf
Hi, I have a case set up and the dates are English (british). I am trying to create a load file where the dates/time reflect this. Within the load file options i have selected the custom dates and set the up to reflect british time/date DD/MM/YYYY however the load file still outputs MM/DD/YYYY how do i change this so the load file dates are in DD/MM/YYYY