Typeform date field bug in Excel | Community
Skip to main content
Answered

Typeform date field bug in Excel


Forum|alt.badge.img+2

I have a date field that is captured correctly in MM/DD/YYYY format but shows up in connected Excel online worksheet as (2023-02-06T00:00:00.000Z). While I can brute-force the final spreadsheet, is there a way of capturing the FORMAT and the DATA correctly in the first place.

Note: I have older surveys that accomplish this with no problems. Change in Microsoft?

Best answer by KDandenell

Found the old answer - had to create a new connection to reset it. Stupid Microsoft.

View original

2 replies

Forum|alt.badge.img+2
  • Author
  • Sharing wisdom
  • 16 replies
  • Answer
  • February 6, 2023

Found the old answer - had to create a new connection to reset it. Stupid Microsoft.


Grace
Community Team
Forum|alt.badge.img+5
  • Community Advocate
  • 2661 replies
  • February 7, 2023

Glad you got it working @KDandenell thanks for sharing the answer here for other excel users ðŸ˜Š


Reply