Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Create list view where one of the properties is of datetime type. 
  2. Use date in the Export Format option. 
  3. 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.
Suggest Edit

Published June 12, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us