Jump to content

CSV Export - date/time format


Recommended Posts

Love your site and the great functionality - it is helping us narrow down our connectivity issues.

It would be super if the export to CSV could put the date/time data into a more data-friendly formatm without the day and the @

Currently the date time comes into Excel like this: Wed Apr 11 2012 @ 4:07:25 pm

and I have to do a decent amount of string manipulation to get something like this: 4/11/2012 4:07:25 PM

so that i can graph the data with a time axis.

Thanks!

Ann at Red House

Link to comment
Share on other sites

Love your site and the great functionality - it is helping us narrow down our connectivity issues.

It would be super if the export to CSV could put the date/time data into a more data-friendly formatm without the day and the @

Currently the date time comes into Excel like this: Wed Apr 11 2012 @ 4:07:25 pm

and I have to do a decent amount of string manipulation to get something like this: 4/11/2012 4:07:25 PM

so that i can graph the data with a time axis.

Thanks!

Ann at Red House

Your welcome! -- I see what you're saying. Try it now and let me know what you think. ;)

-D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...