Ask Your Question
0

Date format doesn't work?

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted
-1

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

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

Comments

"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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 428 times

Last updated: Jul 18 '17