Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-3948

CLONE 2019R2 - Inventory Item Report - Dates are weird

    Details

    • SCRUM Team:
      Globogym Purple Cobras
    • Source Code ID(s):
    • Sprint:
      CFAMX 2019R3 Sprint 3

      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. After.png
          55 kB
          Will Englefield
        2. Before.png
          53 kB
          Will Englefield
        3. SameFormat.png
          82 kB
          Will Englefield

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h
                  1h
                  Remaining:
                  0h
                  Logged:
                  Time Not Required
                  Not Specified

                    PagerDuty

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