LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 01-11-2010, 02:31 PM   #1
Ian D
Member
 
Registered: Aug 2005
Location: Solihull, UK
Distribution: Fedora 9
Posts: 127

Rep: Reputation: 15
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, 02:49 PM   #2
forrestt
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.

HTH

Forrest
 
Old 01-11-2010, 02:55 PM   #3
Ian D
Member
 
Registered: Aug 2005
Location: Solihull, UK
Distribution: Fedora 9
Posts: 127

Original Poster
Rep: Reputation: 15
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, 03:04 PM   #4
ozanbaba
Member
 
Registered: May 2003
Location: Tengiz
Distribution: Slackware64 14.1
Posts: 672

Rep: Reputation: 94
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, 03:24 PM   #5
mark_alfred
Senior Member
 
Registered: Jul 2003
Location: Toronto, Ontario, Canada
Distribution: Ubuntu Linux 16.04
Posts: 1,260

Rep: Reputation: 147Reputation: 147
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 03:32 PM.
 
  


Reply


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 02:56 AM
Date format ust Linux - Newbie 2 12-21-2007 01:39 PM
Date Format dd/mm/yyyy in Suse 10.0 via Webmin collabcomp Linux - Newbie 2 09-15-2007 11:34 PM
Date format Mik LQ Suggestions & Feedback 8 12-05-2004 10:14 AM
why does "ls -l" shows date as YYYY-mm-dd? joroxx Slackware - Installation 2 11-17-2004 10:44 PM


All times are GMT -5. The time now is 07:35 AM.

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