Date field: data missing while exporting

test_amrutha · March 24, 2022, 5:08am

I see date field in Kobo all updated but when I export to excel, some of the values are missing. They appear as blank cells when exported.

Is there any specific reason for this?

Thanks,
Amrutha

Kal_Lam · March 24, 2022, 5:17am

Welcome back to the community, @test_amrutha! Have you checked Store date and number responses as text while downloading your data as shown in the image below?

Checking Store date and number responses as text and downloading your data should solve your issue.

test_amrutha · March 24, 2022, 5:19am

Attaching screenshots: From Excel export, from Kobo Data and Download Settings
I usually unchecked Store date and Number responses as text.

test_amrutha · March 24, 2022, 5:22am

Tried checking and downloading - hasn’t solved the issue unfortunately

wroos · March 24, 2022, 8:11am

Hello @test_amrutha,
would you mind to provide the corresponding screenshot from the table view, please. The cases presented here do not seem to correspond with the cases shown.in the export.

In general order is inverse (and might be further different) between table view and export.