Join the Ready, Set, Send Challenge Week 3. Share your QR code or landing page and win a badge!

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
Employee
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.

Resources
Getting Started with Ideas

Welcome to Ideas! This board is dedicated to providing a space for our intrepid users to provide personal insight and feedback on additions and enhancements they’d like to see in your Constant Contact account.

Read more
Announcements
What's New?

See the latest Constant Contact product release notes and updates.

Learn More