Date format on export
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?
Boris Tsibelman Posts: 994edited December 2020 #2
The export always comes out the same - you would need to manipulate it0
Joanne Clayton Posts: 1edited 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.0
Tobias Stahel_86253 Posts: 1
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 completely0