how to get the creation and close date without time stamp

Mike Janes
Mike Janes Member Posts: 2 VERIFIED MEMBER
edited July 2022 in Sales CRM #1

I am trying to run a report to see how long (days) each deal takes to close, the goal is to see the company average and also by customers (organization). Currently the creation and close data both have time stamp when I download the data into excel even though in insight view, the creation and close date showed only the dates.

image

But once download the data into excel, 

image
6095dc51711d9abba332bd08_60607.png
6095dc8d4808520fd83cee88_23724.png

Comments

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,591 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers
    edited February 2022 #2

    You can always extract just the date part from a date-time field in Excel.

  • Mike Janes
    Mike Janes Member Posts: 2 VERIFIED MEMBER
    edited May 2021 #3

    You can always extract just the date part from a date-time field in Excel.

    Hi Amit, great, it works! Thank you.

This discussion has been closed.