Ask Your Question

How do I use the date function.

asked 2016-05-09 17:02:15 +0100

oscar gravatar image

I want to insert a date into a form with the value YYYY - YY. eg 2001 - 02.

How do I format the date function function to give me the above.

I have found that if I use the YYYY - YY function, libreoffice returns 2001 - 01 instead of my above goal.

Please help if you can.


edit retag flag offensive close merge delete


Is this a Calc question DATE being a standard function in Calc? The DATE function will return a numeric value, not something in a specific format. What is your 'form'? How did you create it? Is YYYY - YY meant to be a 'Numbers' format code? If so you will get "2001 - 01" for every date of the year 2001, of course. Shall the "02" code for February? If so you need the format code YYYY - MM. Did you consider to read the help? A guide?

Lupp gravatar imageLupp ( 2016-05-09 23:42:32 +0100 )edit

@Lupp, I feel it may a request to insert a date field on a form, but as you indicate it is unclear. If it is a date field on a form, it probably needs to be two separate fields IMO.

oweng gravatar imageoweng ( 2016-05-10 07:44:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-05-09 23:39:42 +0100

timelord gravatar image

Hello Oscar

I assume you want Year - Month

The format code is:


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-09 17:02:15 +0100

Seen: 153 times

Last updated: May 09 '16