how to get the creation and close date without time stamp

Options
Mike Janes
Mike Janes Member Posts: 2
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,559
    5 Likes First Anniversary First Answer 5 Up Votes
    edited February 2022 #2
    Options

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

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

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

    Hi Amit, great, it works! Thank you.