Genesys Cloud - Main

 View Only

Sign Up

  Thread closed by the administrator, not accepting new replies.

  • 1.  Incorrect dates on exported csv file

    Posted 04-14-2020 16:31
    No replies, thread closed.
    Hi,

    I'm looking to understand what I need to do to export agent performance data in a proper Date format. The example below shows the year 2003. Also, when I download load the data, the dates are sometimes General or Custom format. Why the inconsistency?
    Finally, can anyone point to a source that can describe how to convert this column into a date format. 

    Thanks,
    Marc 


    #Reporting/Analytics

    ------------------------------
    Marc Moynan
    Canadian Dealer Lease Services Inc
    ------------------------------


  • 2.  RE: Incorrect dates on exported csv file
    Best Answer

    Posted 04-14-2020 18:38
    No replies, thread closed.
    Hi Marc,

    Based on this image, the first part of your report is Custom and the second is General (Excel understand there is no month 13)

    This is more related to your date/time region settings.

    The date format in my region is d/MM/YYYY, but I think your computer is set to YYYY-MM-dd.
    You can check on Control Panel > Region:

    One thing you can try to do is to select a different language when generating your reports, this you will give you a different result (e.g. English US, English GB).


    ------------------------------
    Paulo Mesquita
    Spark NZ Trading
    ------------------------------

    Original Message


  • 3.  RE: Incorrect dates on exported csv file

    Posted 04-14-2020 19:38
    No replies, thread closed.
    Paulo,

    Thanks so much! It works perfectly. I adjusted my computer settings as you suggested.

    Best regards,

    Marc

    ------------------------------
    Marc Moynan
    Canadian Dealer Lease Services Inc
    ------------------------------

    Original Message


Related Content