Community
Select to view content in your preferred language

Suppress time in date-only fields when downloading to CSV/Excel

405
0
11-18-2022 06:24 AM
Status: Open
Labels (2)
Labels
AmyRoust
by
Frequent Contributor

Currently, when you use a Date (not Date and Time) question in your survey, the default time of 6 pm is included in Excel and CSV downloads. 

In the survey:

AmyRoust_0-1668781313236.png

In the exported CSV and Excel:

AmyRoust_1-1668781365276.png

 

When we use the Date only field, we do so because a time is not relevant to the data collection. We would prefer to have a consistent experience in the download so that we don't need to take the extra step of removing the time.