Details

      Description

      When viewing the Downloaded report, in excel, the date format appears to have changed, in addition to the fact that the dates are in the csv in the wrong format.

      • Dates should be in mm/dd/yyyy hh:mm:ss AM/PM format
        • in the file they are dd/mm, not mm/dd
      • In addition to this, something seems to have happened to the way that Excel is reading the dates, since the update that were made yesterday, or was it because we rolled to 5/1 and excel is confused as to what to display?
        • Excel vs csv (Dates are in the same format in the csv for all days)
        • When looking at the format of the cells in excel, there is a difference, this is not something that I have done, others are seeing it too
        • Dates before 5/1
        • Dates after 5/1

        Attachments

        1. SameFormat.png
          82 kB
          Will Englefield
        2. Before.png
          53 kB
          Will Englefield
        3. After.png
          55 kB
          Will Englefield
        4. InventoryItemsByVendorOrders_CA.csv
          9 kB
          Francois Steenkamp
        5. InventoryItemsByVendorOrders.csv
          9 kB
          Francois Steenkamp

          Issue Links

            Activity

              People

              • Assignee:
                Gareth.Leibbrandt Gareth Leibbrandt (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 15h
                  15h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.