Date format on export

Lucas Xavier_3197
Lucas Xavier_3197 Posts: 30
edited July 22 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 Community Driver Posts: 1,033
    1000 Comments Second Anniversary Combo Breaker Photogenic
    edited December 2020 #2

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

  • Joanne Clayton
    Joanne Clayton Posts: 1
    edited January 20 #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.