datetime - How to return DATE from DATE TIME in Openoffice -


i have openoffice calc column following entries:

10/21/12 09:39 12/20/12 05:35 04/30/13 12:47 pm 

how extract date part output is:

10/21/12  12/20/12  04/30/13  

just apply rounddown() or int() date value strip time information; may have apply date formatting manually.

the date value 10/21/12 09:39 am internally stored 41203.4020833333 calc. calc uses integers dates , fractions time values. so, date part of 10/21/12 09:39 am 41203. rounding down value 41203.4020833333 41203 strips time information, leaving date (to precise: result 10/21/12 00:00 am - it's matter of formatting cell date or date/time.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -