Hello, I am sure this is a simple thing but cannot seem to find a solution on my own. I get data from someone who pulls it from a SQL table and the date comes in the format of "12/28/2010 7:47:55 AM"
I only need the date, how do I get the time removed. I can change the way the field formats the data to only show the time but that doesn't help me when I do a pivot table as each time results in there being many instances of the same date.
Thanks,
Steve
Last edited by Huzzah; 04-04-2011 at 12:04 PM.
=INT(A1) will just return the date part of a serial date/time value.
Have you tried grouping your date/time values in your pivot by days though?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Originally Posted by Domski
Thank you, for both replies. I completely forgot about the pivot table grouping options, that is the easiest solution! It's still good for me to have the other solution though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks