| I'm reading an Excel sheet using the SpreadsheetQueryread() and one | column contains a date in the format of 01.02.2012 eg. 1'st of Ferbruary | 2012 | Now... this lands in my query as a value 40940... | What's the correct way to get that back as a Date?
Hej Mats, Just for the record - that column contains text/strings, right? Not Excel date formats (which I think are a big int of some kind in raw format). Cheers, Hugo -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
