BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-02-2009, 11:02 AM   #1 (permalink)
New Member
 
Join Date: Jun 2009
Model: 9000
PIN: N/A
Carrier: AT&T
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Post Dates in spreadsheet are different on Blackberry vs. PC

Please Login to Remove!

Odd issue here.

I have an excel spreadsheet, with dates on it.

When viewed on the PC, the dates show to be in the year 2009

when viewed on the blackberry, the dates show to be in 2005, a day earlier.

What causes the problem?

Example data:
On blackberry: 10/19/2005
On PC: 10/20/2009

Any ideas on this one?

Thanks for your help!

Last edited by instant000 : 09-02-2009 at 11:12 AM.
Offline  
Old 09-02-2009, 11:50 AM   #2 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

Not that it should matter, but is the date/time/year correct on the BlackBerry? Does it do this if you open the spreadsheet on a different device?
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 09-02-2009, 04:01 PM   #3 (permalink)
New Member
 
Join Date: Jun 2009
Model: 9000
PIN: N/A
Carrier: AT&T
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I can't verify their devices (multiple people reported this), but I can definitely say that the date/time is correct on my own device, and they emailed me a copy after discovering the problem.
Offline  
Old 09-02-2009, 04:22 PM   #4 (permalink)
New Member
 
Join Date: Jun 2009
Model: 9000
PIN: N/A
Carrier: AT&T
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

the problem is the 1904 date system!
microsoft kb/214330

I can't post links yet (not enough posts), only three or so at this time ... but someone answered my question on this at the ATT forums.
Offline  
Old 09-02-2009, 08:46 PM   #5 (permalink)
BlackBerry Extraordinaire
 
Join Date: Oct 2007
Location: Los Angeles
Model: None
PIN: N/A
Carrier: ATT
Posts: 1,638
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here's the link:
Description of the differences between the 1900 date system and the 1904 date system in Excel

To set the date system for a workbook in Microsoft Office Excel 2003 and in earlier versions of Excel, follow these steps:

1. Open or switch to the workbook.
2. On the Tools menu, click Options. In Excel X and later versions for Macintosh, click Preferences on the Excel menu.
3. Click the Calculation tab.
4. To use the 1900 date system in the workbook, click to clear the 1904 date system check box. To use the 1904 date system in the workbook, click to select the 1904 date systemcheck box.
5. Click OK.

To set the date system for a workbook in Microsoft Office Excel 2007, follow these steps:

1. Open or switch to the workbook.
2. Click the Microsoft Office Button, and then click Excel Options.
3. Click Advanced.
4. Click to select the Use 1904 data system check box under the When calculating this workbook, and then click OK.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.