Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 01-11-2010, 03:31 PM   #1
Ian D
Registered: Aug 2005
Location: Solihull, UK
Distribution: Fedora 39
Posts: 215

Rep: Reputation: 18
dd/mm/yyyy date format

I am English. I write dates in the dd/mm/yyyy format.

I tried to enter two consecutive Sundays (03/01/10 and 10/01/10) in to the Open Office Spreadsheet, and then propagate more dates by dragging the box down the column. The dates I got were odd. Then I realised that the system thought I was talking about 1st March and 1st October and was doing the best it could with that strange pair of dates.

Presumably, there is a setting somewhere to tell Linux (Fedora 10) that I want to write the day, then the month and not the other way round. I could not see it.
Old 01-11-2010, 03:49 PM   #2
Senior Member
Registered: Mar 2004
Location: Cary, NC, USA
Distribution: Fedora, Kubuntu, RedHat, CentOS, SuSe
Posts: 1,288

Rep: Reputation: 99
Inside OpenOffice you need to go to Tools->Options expand Language Settings and click Languages. Change Locale setting to "English (UK)". You will need to reenter your dates though as as soon as you make the change, they will switch from the dates as OOo thinks you meant them to the English equivalent of those. I think you can also set the "LANG" environment variable to do the same thing, but am not sure what it would be set to or even if that would work.


Old 01-11-2010, 03:55 PM   #3
Ian D
Registered: Aug 2005
Location: Solihull, UK
Distribution: Fedora 39
Posts: 215

Original Poster
Rep: Reputation: 18
Many thanks forrestt,

I tried looking in Open Office but didn't have too much time and nothing leapt out at me.
Old 01-11-2010, 04:04 PM   #4
Registered: May 2003
Location: İzmir
Distribution: Slackware64 15.0 Multilib
Posts: 778

Rep: Reputation: 135Reputation: 135
i don't know the fedora, but usually programs get their locale settings from $LANG variable. locale -a will give you the list
Old 01-11-2010, 04:24 PM   #5
Senior Member
Registered: Jul 2003
Location: Toronto, Ontario, Canada
Distribution: Ubuntu Linux 16.04, Debian 10, LineageOS 14.1
Posts: 1,572

Rep: Reputation: 210Reputation: 210Reputation: 210
I think it's actually under Format - Cells. Here you'll see options for setting up the date (specifically, format cells - numbers - category "date", and then choose how you wish them to be formatted.) I think the language settings/locales are for spell checks and for spelling within the application as a whole. My set up is a UK interface with a Canadian locale; hence, "centre" and "neighbour". However, even though this is the case, I could still have my dates formatted in American style (mm/dd/yyyy), international (yyyy/mm/dd) or Canadian (dd/mm/yyyy) if I so choose. Or, other date options, regardless of the locale, are also available (such as having the month written out, etc.)

Last edited by mark_alfred; 01-11-2010 at 04:32 PM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format ZAMO Linux - General 1 02-11-2009 03:56 AM
Date format ust Linux - Newbie 2 12-21-2007 02:39 PM
Date Format dd/mm/yyyy in Suse 10.0 via Webmin collabcomp Linux - Newbie 2 09-16-2007 12:34 AM
Date format Mik LQ Suggestions & Feedback 8 12-05-2004 11:14 AM
why does "ls -l" shows date as YYYY-mm-dd? joroxx Slackware - Installation 2 11-17-2004 11:44 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:46 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration