Community Member Profile
Chris McCowan
Member since Feb 14, 2011
- Profile: /members/7798-Chris-McCowan.htm
- URL: http://www.11elements.com
- Comments: 1
- Points: 10
Recent Blog Comments By Chris McCowan
-
Reading Excel Files With ColdFusion And POI
Posted on Feb 14, 2011 at 6:40 AM
@ Jorge : Regarding the 4 digit excel date format, it is Julian encoded. Try dateadd("d",THEVARIABLEYOUNEEDTOCONVERT,createdate(1900,1,1)) or dateformat(dateadd("d",THEVARIABLEYOUNEEDTOCONVERT,createdate(1900,1,1)), "mm/dd/yyyy") for output... read more »
