TylerN
Level 1

QBSE Can't export sorted trips correctly

I need to be able to reliably sort my trips like this:

TYPE: Business
DATE: 2018
SEARCH: "Van" (Trip purpose)

And then export only those specific trips, but also ALL of those specific trips.

 

When I sort by Year, Business, and Trip Purpose (the vehicle I used), it sorts as expected on screen, but when I export it gives me every trip for that year - even personal trips (except for anything on 12/31).

 

When I export any mileage for 2018 it only includes 1/1/18 - 12/30/18. Where is 12/31/18? I have tracked 3 trips on that day. This happens when exporting directly to my computer as .xls while sorted by date: 2018. If I export to email as .csv it includes 12/31/18 but also includes  all of 2017 and 2019 even though I sort by date: 2018.

 

The only time exporting sorted trips seems to work is if I sort by personal. Then I export only personal trips - but still nothing on 12/31/18.