Troubleshooting: Format of Date Fields Includes Time

Becky Nibe -

Changing up the format of date fields is on the development list, but in the meantime, you can remove that in Excel pretty quickly. Highlight the column and use the Find & Select..Replace option (depending on your version of Excel) to find " 12:00:00 AM" and replace it with (leave that cell blank).

Another quick way (in Excel) to remove the time portion of the field is to use the "text to columns" feature to split the date column into two separate columns, then report the one that contains the time portion. See this Excel article for more details.


Please sign in to leave a comment.
Powered by Zendesk