[cfaussie] Date format

2007-04-03 Thread Tom MacKean
Hi all, I am using ColdFusion to drag some data kicking and screaming out of a very strange MS-based database. The date of birth field has values such as 716640 and 712672. After a bit of mucking about I discovered that I can place this value in an excel cell and change the format to date to

[cfaussie] Date format

2007-04-03 Thread Karen Johnstone
Hi Tom, According to http://www.joelonsoftware.com/items/2006/06/16.html: In most modern programming environments, dates are stored as real numbers. The integer part of the number is the number of days since some agreed-upon date in the past, called the epoch. In Excel, today's date, June