• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Date value at Excel 2004
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Date value at Excel 2004

  • Subject: Re: Date value at Excel 2004
  • From: Doug McNutt <email@hidden>
  • Date: Wed, 7 Dec 2005 10:46:14 -0700
A philosophy question:

Excel internally stores dates as a floating point value with a day as the unit. The epoch point is Jan 0, 1904 for Macs and Jan 1, 1900 for peecees (with dates before 27 Feb 1900 one day off.).

On a Mac the date value multiplied by seconds in a day should equate to the original unsigned 32 bit Mac date but I have no idea what happens in a 64 bit epoch that doesn't roll over in 2034.

It would seem that asking Excel for the range.value part of a cell that happens to contain a date would return an IEEE float which AppleScript could handle appropriately. .

The question:

Does anything like that happen under the hood? Such a transfer would be independent of such things as m/d/y and d/m/y international confusion and the format that a user applied to the cell being addressed.

Microsoft did something right with the use of floating point days. Overflow occurs gradually in both directions of time while retaining useful precision for both geologic history and Star-Wars astrodates..

--
--> The Intelligent Designer managed to create the only species that kills its own members while claiming that it acts in accordance with God's word. <--
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
References: 
 >Re: Date value at Excel 2004 (From: Paul Berkowitz <email@hidden>)
 >Re: Date value at Excel 2004 (From: Gonçalo Miguel <email@hidden>)

  • Prev by Date: Re: Check For Open Application
  • Next by Date: Re: Setting 'open with' via AS?
  • Previous by thread: Re: Date value at Excel 2004
  • Next by thread: Re: Check For Open Application
  • Index(es):
    • Date
    • Thread