News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Conversion of a date f...

Customer experience | Sales, Customer Insights,...

Unanswered

Conversion of a date field exported to Excel

(1) Share

Report

Report

Posted on by CU25091352-0

6

Hi,

we have a date field in Dynamics table that exported in a Excel files becomes a 15 digits field, for example 454606871064815.

The question is, how can I convert this 15 digits number in Excel back to a date ?

Thanks in advance, Max.

All responses Img

All responses (2)

Answers Img

Answers (0)

CU25091352-0 6 on at

Like (0)

Report

Conversion of a date field exported to Excel

Thanks, I already tried what suggested by Affan, but It doesn't work. The field should also include the time.
Muhammad.Affan 4,449 on at

Like (4)

Report

Conversion of a date field exported to Excel

Hi There,

In excel, click on the date column and change the format of the cells as shown below:

Finally, once your issue is resolved and my suggested answer has helped, please do not forget to click Yes under "Did this answer your question?" to close this thread.

Thanks
Affan
Follow my channel related to Dynamics 365: https://www.youtube.com/@AffansDynamicsJourney

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans