Skip to main content

Notifications

Dynamics 365 Community / Forums / Sales forum / Date/Time update in Ex...
Sales forum
Suggested answer

Date/Time update in Excel dynamic workbook not working

Posted on by 25

Hello! 

I am not sure if my issue was already discussed, I apologize if so, I was not able to find anything relevant to my issue.

I exported some data to a dynamic excel worksheet, the data update works fine with one exception: the values of when the records have been created disappears after refreshing,. I assume it is because Excel cannot recognize the date and time in the cell. Is there a way to format this so that it only shows the date or can I format the cell in a way that is recognizes the date and time value after refreshing? I attached a screenshot for better understanding. Thanks so much for your help, guys, I appreciate it!

This is after the export:      An after:

Screenshot-2021_2D00_07_2D00_09-141356.pngScreenshot-2021_2D00_07_2D00_09-141446.png The error shown: Dates and Times that are negative or too large show as ####

The cell seems to be formated as Date and time Screenshot-2021_2D00_07_2D00_09-141621.png, but it does not show a date even if I try to format it as date. 

Thanks so much,

  • dewainc Profile Picture
    dewainc 2 on at
    Date/Time update in Excel dynamic workbook not working

    Hallo,

    I have the same issue.

    Have you managed to solve it? 

    i can't find this problem on other forum

  • Suggested answer
    KK-365 Profile Picture
    KK-365 1,010 on at
    RE: Date/Time update in Excel dynamic workbook not working

    You can change the format type of the column to short date as shown in below screenshot.

    pastedimage1660567509416v1.png

    Please mark this answer verified once your issue is resolved.

  • Andoni Profile Picture
    Andoni 5 on at
    RE: Date/Time update in Excel dynamic workbook not working

    Hi Maddy,

    I have the same issue.

    Have you managed to solve it?

    Increasing the width of the column didn´t solve it

  • Madelaine Profile Picture
    Madelaine 25 on at
    RE: Date/Time update in Excel dynamic workbook not working

    Hi,

    Thanks so much for your answer. Do I need to make sure the field is wide enough right after exporting the data? After the next refresh, the outcome is always the same, even when I increase the width of the field. Is there something else I can do to prevent this?

    Thanks!

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Date/Time update in Excel dynamic workbook not working

    Hi,

    Thank you for your query.

    Increase the width of the column, it will show the value.

    Initially, when you export due to less width it shows masked DateTime value:

    pastedimage1625951781260v1.png

    But when we increase the width, it shows the actual DateTime value:

    pastedimage1625951822482v2.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans