Dot separated date in YYYY.MM.DD format

users
#1

Hello all,
In a spreadsheet, I need the dot separated date in YYYY.MM.DD format, e.g.
2015.01.012015.12.11
Should I file a bug report to add this feature? Is it currently not available?

Please advise. Thanks.

C. H. D.
 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _

#2

I think it is already available.
You have to change the cell format (date type) in YYYY.MM.DD, nothing
more....

Federico Quadri

"C. H. D." <webofht-libreoffice001@yahoo.com.hk> ha scritto:

Hello all,
In a spreadsheet, I need the dot separated date in YYYY.MM.DD format,

e.g.

#3

In a spreadsheet, I need the dot separated date in YYYY.MM.DD format, e.g. 2015.01.012015.12.11

In the Format Cells dialogue, you can create your own "User-defined" formats. Just enter your "YYYY.MM.DD" in the "Format code" box there. Some formats get complicated by locale-specific properties, but I doubt there is any problem with this one.

Alternatively, you could always create a formula to develop from a genuine date value a text string (in a separate cell) representing any format you wanted.

Should I file a bug report to add this feature?

Probably not.

Is it currently not available?

It is - as above.

I trust this helps.

Brian Barker

#4

Hello C.,

In a spreadsheet, I need the dot separated date in YYYY.MM.DD format,
e.g. 2015.01.012015.12.11

Go to Format Menu, Cells... then select Numbers tab -> Time. Enter time
in the format you require in the entry box.

Should I file a bug report to add this feature? Is it currently not
available?

No bug report required. Not all options are offered "out of the box";
There are simply way too many permutations.

#5

Hi all:

  I think you need to use this format: YYYY/MM/DD

Regards,

Jorge Rodríguez

#6

I suspect you would have more success using the ISO format of
YYYY-MM-DD instead of a non-standard format.

#7

Why? Load a Calc document and apply English YYYY.MM.DD or German
JJJJ.MM.TT, Spanish AAAA.MM.DD or anything like that. Checking this out
takes not more than a minute.