HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Reports. Remove DAY from data & Sort OLD to NEW in DATA SET


I’m using Helpspot 2.6. My problem is when I run a report the DATA SET lists NEW to OLD and EXPORT CSV lists NEW to OLD. There are two specific problems.

  1. Even when I sort OLD to NEW in Data Set, the data is listed as NEW to OLD when EXPORT CSV is run and opened EXCEL. Normally I would reverse the sort, but…
  2. The data is [Mon, April 16, 2012] in a single cell.
    That data doesn’t sort easily without a lot of scrubbing.

I want the EXPORT CSV to created the data as 04/16.2012
Even not exporting the DAY would provide some relief.