Date format on export

lucasmx
lucasmx Member Posts: 18 VERIFIED MEMBER
First Comment First Anniversary Photogenic Combo Breaker
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?

Tagged:

Comments

  • Boris Tsibelman
    Boris Tsibelman Member Posts: 832 VERIFIED MEMBER
    5 Likes Third Anniversary Photogenic First Comment
    edited December 2020 #2

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

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

    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
    Tobias Stahel_86253 Member Posts: 1 VERIFIED MEMBER
    First Comment
    #4

    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

This discussion has been closed.

Categories