Hi Everyone,
Greetings!
I stumbled this somewhat 'uninvited' result while using data format of
the CellStyle.
Below is the details of what I have found:
Format used: *yyyymmdd h:mm AM/PM*
Input: *2013-09-06 14:01:41.673662*
Desired result: *20130906 2:01 PM*
Actual result: *20130906 2:01 PM
*Given this information, as you can see, the result was satisfying.
Below is another details:
Format used: *yyyymmdd h:mm AM/PM*
Input: *2013-09-07 12:36:13.614938*
Desired result: *20130907 12:36 PM*
Actual result:*################
*12 o'clock shares the same result with 11 o'clock and 10 o'clock. I
observed that having 2 digits on the hour field will return the given
result.
I've been wondering if the given scenario is a bug or I'm missing something.
**
Thanks and Regards,
--
*Michael Ardan*
Jr Analyst/Developer
*eScience Corporation*
Tel (632) 8501324
Fax (632) 8427408
Mobile (63) 926-3145737
YM [email protected]
/This e-mail message (including attachments, if any) is intended for the
use of the individual or the entity to whom it is addressed and may
contain information that is privileged, proprietary, confidential and
exempt from disclosure. If you are not the intended recipient, you are
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify the sender and delete this E-mail
message immediately./
