Support Article
Time also getting exported along with date in Export to Excel
SA-10577
Summary
Developer has created a list view with datetime type property. Then used date in the Export Format option but still time is also getting exported along with date when exporting to Excel.
Error Messages
Not Applicable.
Steps to Reproduce
- Create list view where one of the properties is of datetime type.
- Use date in the Export Format option.
- Export to Excel and see time also exported along with the date.
Root Cause
As long as you are using a datetime type property Excel will add the default time value along with the date vaule.
Resolution
Using date type property will solve the issue.
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.