Customer experience | Sales, Customer Insights,...

Date/Time update in Excel dynamic workbook not working

(0) Share

Report

Posted on by Madelaine

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:

The error shown: Dates and Times that are negative or too large show as ####

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

Thanks so much,

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Wahaj Rashid 11,323 on at

Like (1)

Report
Copy link

Link copied!

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:

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

Was this reply helpful? Yes No
Madelaine 25 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Andoni 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Maddy,

I have the same issue.

Have you managed to solve it?

Increasing the width of the column didn´t solve it

Was this reply helpful? Yes No
Suggested answer

KK-365 1,010 on at

Like (0)

Report
Copy link

Link copied!

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

Please mark this answer verified once your issue is resolved.

Was this reply helpful? Yes No
dewainc 2 on at

Like (0)

Report
Copy link

Link copied!

Hallo,

I have the same issue.

Have you managed to solve it?

i can't find this problem on other forum

Was this reply helpful? Yes No