Ask Your Question

Date format doesn't work? [closed]

asked 2017-07-18 04:32:47 +0100

daveqeh gravatar image

I set a column to be date format YYYY-MM-DD but if I put in July 14, 2015 it doesn't convert it. What am I doing wrong?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 23:32:58.948369

1 Answer

Sort by » oldest newest most voted

answered 2017-07-18 05:49:05 +0100

robleyd gravatar image

You need to enter the date in a format that Calc will recognise as a date - starting with July causes Calc to interpret the input as text.

See sections 2 and 3 of this article for more information.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more


"starting with July causes Calc to interpret the input as text" actually is not true, but it depends on the locale what strings are recognized as dates. In an English-US locale July 14, 2017 is perfectly recognized as date, but in a non-English locale of course it is not.

erAck gravatar imageerAck ( 2017-07-19 10:00:30 +0100 )edit

Question Tools

1 follower


Asked: 2017-07-18 04:32:47 +0100

Seen: 728 times

Last updated: Jul 18 '17