Date format on export

Options
lucasmx
lucasmx Member Posts: 18
Name Dropper Combo Breaker Photogenic First Anniversary
edited July 2022 in Sales CRM #1

Hello,

 

Periodically i export all my deals of Pipedrive to audit with my Salesforce database, while salesforce exports the date as Day-Month-Year format, Pipedrive only exports as american format, forcing me everytime to create formulas to convert the date format. 

Is there any option I've missed to choose a date format on XLS export of Pipedrive data?

Comments

  • Boris Tsibelman
    Boris Tsibelman Member Posts: 843
    5 Likes First Anniversary First Answer Combo Breaker
    edited December 2020 #2
    Options

    The export always comes out the same - you would need to manipulate it

  • Joanne Clayton
    Joanne Clayton Member Posts: 1
    edited January 2022 #3
    Options

    Has anyone found a quick excel formula solution for this? I've got a solution but it's quite longwinded for reports that have to be regularly updated.

  • Tobias Stahel_86253
    Options

    it would be great to be able to use the data in excel (dates recognized as dates) since the built in reporting functionalities are not very use ful: no comparison between time periods (e.g. amounts of sales 2021 vs. 2022 vs. current year, on monthly bases).

    unless i missed this completely