augustinesoftware.com
September 20, 2017, 06:58:36 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: TimeSheet and TimeSheet Lite Released!
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Problem with Dates in the CSV file,  (Read 8231 times)
arghh2010
Newbie
*
Posts: 1


« on: February 01, 2010, 11:08:56 AM »

Entry Start Date   Entry End Date
10/1/2027 17:00   10/1/2027 18:00

Above is how Excel parses the dates for this format.
Tried many custom format and could not make it work.

The text sent is 2010-01-27
I would expect Excell to show me Jan 27 2010, not  Jan 10 2027. 
Logged
Charles Augustine
Administrator
Hero Member
*****
Posts: I am a geek!!


« Reply #1 on: February 01, 2010, 12:36:48 PM »

Hi there,

Unfortunately the only copy of Excel I have to test with works fine when interpreting 2010-01-27 as a date in 2010 (it shows me Jan 27, 2010).  What version of excel/office are you using?

-- Charles
Logged
qwerty20
Newbie
*
Posts: 1


WWW Email
« Reply #2 on: July 24, 2010, 08:08:45 PM »

Actually, I'm not good at Excel.
Logged

phelpme
Newbie
*
Posts: 1


WWW Email
« Reply #3 on: August 03, 2010, 08:44:09 PM »

Sorry, can't help that
Logged

kidstom
Newbie
*
Posts: 1


WWW Email
« Reply #4 on: September 20, 2010, 11:46:05 PM »

solve that?
Logged

Charles Augustine
Administrator
Hero Member
*****
Posts: I am a geek!!


« Reply #5 on: September 21, 2010, 12:47:16 AM »

I've had a few people come to me with this problem and it seems to generally be an issue with Excel configuration.  I know at least a few have gotten it sorted out; next time it happens I'll ask them for a solution.  Unfortunately I am unable to reproduce it with the version of Excel that I own.
Logged
Spoivediops
Newbie
*
Posts: 38


I respect faith, but doubt is what gets you an education. ~Wilson Mizner [url="http://idipic.com/"]funny[/url]

248048633 persil226@gmail.com 331347526 BubenubyChony
WWW
« Reply #6 on: May 28, 2012, 05:42:09 PM »

HuhHuh?? Huh?? - HuhHuh? HuhHuhHuh ? ?? HuhHuh? HuhHuh?? ?? HuhHuhHuh HuhHuhHuh Huh??  Huh HuhHuhHuh? HuhHuhHuh HuhHuh?? Huh ?? ?? Huh ?? HuhHuh - ?? Huh? HuhHuhHuh?. .
Logged

I believe in rules.  Sure I do.  If there weren't any rules, how could you break them?  ~Leo Durocher  foto
Spoivediops
Newbie
*
Posts: 38


I respect faith, but doubt is what gets you an education. ~Wilson Mizner [url="http://idipic.com/"]funny[/url]

248048633 persil226@gmail.com 331347526 BubenubyChony
WWW
« Reply #7 on: May 28, 2012, 06:52:53 PM »

? Huh?? ? ?? Huh??.  HuhHuh? Huh?? ?? HuhHuh? jimm  HuhHuh Huh?? HuhHuhHuh? HuhHuhHuh?? Huh??. .
Logged

I believe in rules.  Sure I do.  If there weren't any rules, how could you break them?  ~Leo Durocher  foto
Spoivediops
Newbie
*
Posts: 38


I respect faith, but doubt is what gets you an education. ~Wilson Mizner [url="http://idipic.com/"]funny[/url]

248048633 persil226@gmail.com 331347526 BubenubyChony
WWW
« Reply #8 on: June 03, 2012, 05:26:25 PM »

I'll bet five!
Logged

I believe in rules.  Sure I do.  If there weren't any rules, how could you break them?  ~Leo Durocher  foto
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.12 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!