Brian LeGros Presenting at the IECFUG this Friday: SVN
The session will be recorded if you can't catch it live at the following address at 7pm Pacific: http://adobechats.adobe.acrobat.com/r50449390/
The session will be recorded if you can't catch it live at the following address at 7pm Pacific: http://adobechats.adobe.acrobat.com/r50449390/
Anyways, to sum up the problem
Excel stores dates as numbers therefore the only way to determine if a cell is actually stored as a date is to look at the formatting.
Enter a little digging in the docs and the API and you find the famous HSSFDataFormat class.
This class will help you get the correct formatting for any kind of date, datetime, etc.
CF tags:
CFCOLLECTION
CFCONTENT
CFEXECUTE
CFLOG
CFOBJECT
CFOBJECTCACHE
CFREGISTRY
CF functions:
SetProfileString
CreateObject(COM)
CreateObject(CORBA)
CreateObject(JAVA)
Not only that, they have given no warning to their customers. I had to email them that a friend of mine told me. So here is the deal where they screw up. Under their terms of service they write:
2. Web Hosting Services
For the term of the agreement as set forth herein DAILYRAZOR agrees to provide web hosting services according the plan selected by you upon activation of your account. DAILYRAZOR reserves the right to change, amend and/or otherwise alter the services provided with equivalent or otherwise equal services without prior notice to you.
The last line says it all:
provided with equivalent or otherwise equal services without prior notice to you.
The fact of the matter is that they will NOT be providing equal services. They will be hindering services and breaking applications. Not only that, the amount of time needed to transfer and recreate the applications and websites in another host will take weeks.
I need legal counsel or should I just seek alternatives and take in the damages?? What do you guys recommend?
Any recommendations?
Anyways, to sum up the problem
Excel stores dates as numbers therefore the only way to determine if a cell is actually stored as a date is to look at the formatting.
Enter a little digging in the docs and the API and you find the famous HSSFDateUtil class. This class contains a bundle of static methods for you to check and validate date formatting in excel.