Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Champion

Date formats in Bulk Download Member data/ Community Analytics

Hello

I am having issues with the bulk download member data csv

Here's an example from my file today where everything is in DD/MM/YYYY format:

Screen Shot 2022-08-05 at 9.27.57 AM.png

In other parts of the sheet the data is aligned left or right:

Screen Shot 2022-08-05 at 9.34.55 AM.png

I am working with Google Sheets and trying to sort the data by month/date/year but I can't transform the date format into month first. 

Also incidentally there is the empty row below the header row which is very irritating. 

Anyone working in Google sheets with any tricks to transform this data quickly with a formula to get it all into the right format. I've exhausted the Custom Date Format options and checked all my systems settings are in the desired output date for MM/DD/YYYY

Thanks

Senior Community Manager | Strava
https://communityhub.strava.com
0 Replies 0

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.