https://issues.apache.org/bugzilla/show_bug.cgi?id=52349
--- Comment #2 from Michael L. <[email protected]> 2011-12-17 15:28:56 UTC --- Doesn't matter which month you pick, it does the same thing. I originally tested both with and without a time component, but the time I used had 0 minutes (and I got the same response in both cases). You are probably right about it being a mix-up between month & minute, because if you adjust the formula from: =TEXT(A1, "mmddyyyy") to =TEXT(A1, "MMddyyyy") then the FormulaEvaluator works correctly. Looking at Excel's help (under TEXT function - Guidelines for date and time formats): http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx?CTT=5&origin=HA010277524 it appears that Excel does not use the same formatting as Java's SimpleDateFormat -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
