Removing time (Hours/Minutes) value from Created Date
I would like to have the values presented in the Deal Created section to only show Day-Month-Year and not have the minutes & hours shown. That is of zero value to me when running a report and, when exporting to Excel, it makes it more difficult to sort by that value. The Last Activity and Last Stage Change represent the way I desire. Any ideas? I have scoured the support documentation and not seen anything.
Comments
-
When running a report in Excel, you can format it as DD/MM/YYYY as a separate column.
0 -
Amit Sarda said:
When running a report in Excel, you can format it as DD/MM/YYYY as a separate column.
Well, there are a few problems. First, I would ideally like the hours/minutes not to display in Pipedrive. Secondly, when in Excel, the values do not change whether I modify the existing column or add a column and copy paste. The only thing that works is if I manually overwrite the values, removing the time portion. Nothing seems locked but there obviously is a bug somewhere (human or otherwise). You can see here where I have overwritten the value that came from Pipedrive with just the date. It is formatted to the cell. But no other cells have updated...
0 -
Amit Sarda said:
When running a report in Excel, you can format it as DD/MM/YYYY as a separate column.
You will find this useful: https://corporatefinanceinstitute.com/resources/excel/functions/excel-text-function/
If you have any other questions, I'd be happy to help.
Best,
0 -
Amit Sarda said:
When running a report in Excel, you can format it as DD/MM/YYYY as a separate column.
Thank you. I will definitely try this out.
0
