csv export option to format date

0 Votes
when i export csv of campaigns, date comes with date and time, and i am unable to change the format in excel (i.e. remove time, want only date)
2 Comments
Caitlin_M
Administrator
Status changed to: Voting Open

Hi @web_design1. I apologize for the delay in our reply but thank you for bringing this to our attention. I'm seeing the same thing happen when I download a CSV file of campaigns. There is a workaround by using the text to column feature in Excel that can make the column editable. I'll include a third-party link that includes more information about how to achieve this but please note that our support teams would not be able to assist with the creation of this file and it would need to be done on your own time. I'll open this request up for voting. 

Frankie_P
Moderator
Status changed to: Closed - No Action

Hi everyone,

 

The good news is you can update this formatting in excel by highlighting column > Number > Short Date. Because this is also more of an Excel related issue, we recommend contact support directly. We are also going to close this idea. This doesn't mean that we aren't listening to your feedback! Please feel free to comment or vote on any of the other open ideas to let us know what you would like to see.

What happens with product feedback?

Find out about the life-cycle of a product idea when it is posted on our Feedback board.

Read More

What's New

See the latest Constant Contact product release notes and updates.

Learn More