5 Replies Latest reply: Apr 7, 2016 2:01 AM by kushal chawda RSS

    Time & date interpretation

    Nicklas Thorén

      Hi,

       

      Newbie question perhaps....

       

      I'm using QV to analyze a large logfile that is generated once per week. The logfile contains a combined date and time field which is loaded in to my application and looks like this by default:

       

      YYYY-MM-DD HH:MM:SS, example: 2016-04-02 00:04:29

       

      The logfile contains several hundered lines that have the same date, but different time stamps (seconds between them)

       

      My application doesn't depend on the timestamps, I only need the date. By modifying the load script I'm able to bypass the timestamp, however then I create a listbox containing the date field my application lists every single line containing a date, se my example below:

       

      2016-04-02

      2016-04-02

      2016-04-02

       

      My assumption is that the listbox shows me all of the dates equivalent to the number of occurrences, not by "grouping" the dates.

       

      I would like the listbox to only contain one date at a time, example below:

       

      2016-04-02

      2016-04-03

      2016-04-04

       

      Regards,


      Nicklas