[Klug-general] The date as a number

Jeremy King jeremy at jandcking.com
Fri Sep 4 09:20:38 UTC 2009


This comes from MS Excel in history.  01 Jan 1900 is day 1 and 31 Dec
1899 is day 0.
The date is stored as a number internally and is rendered to the user by
formating the field as a date.

On Fri, 2009-09-04 at 09:46 +0100, J Subs wrote:
> I'm working in OpenOffice.org and the date is represented as a number 
> (eg 39904 is Wednesday, April 01, 2009). Is there a lookup table 
> somewhere I can find this information? And what's it known as, in 
> computer parlance? Something like Unix time?
> 
> thanks, Jake
> 
> _______________________________________________
> Kent mailing list
> Kent at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/kent
-- 

Jeremy King
jeremy at jandcking.com
Tel: +44 (0)77 7047 4419




More information about the Kent mailing list