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:MMS, 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:
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:
Note that Date() on its own does not change the underlying value. It formats the text form of the date/time value, but does not remove the time, so you land up with a whole lot of different values that look the same.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein