Luftwaffe and Allied Air Forces Discussion Forum  

Go Back   Luftwaffe and Allied Air Forces Discussion Forum > Discussion > Luftwaffe and Axis Air Forces

Luftwaffe and Axis Air Forces Please use this forum to discuss the German Luftwaffe and the Air Forces of its Allies.

Reply
 
Thread Tools Display Modes
  #1  
Old 21st August 2005, 18:09
John Beaman John Beaman is offline
Super Moderator
 
Join Date: Dec 2004
Location: Greensboro, North Carolina, USA
Posts: 2,155
John Beaman is an unknown quantity at this point
Date convention

Guys:

When mentioning a date, let's all use the convention like 20-Aug-05 rather than 05-08-05. With people from all over the world coming to this site, that last reference could be August 5th or May 8th.

Thanks
Reply With Quote
  #2  
Old 21st August 2005, 19:07
S Sheflin S Sheflin is offline
Senior Member
 
Join Date: Dec 2004
Location: Califiornia, USA
Posts: 735
S Sheflin will become famous soon enough
Re: Date convention

Hi John,

Devil's advocate here. How about a YY-MM-DD convention?

For example: 45-05-08.

I utilize this format in my databases. It makes for easy sorting and is, I think, unambiguous.

Best regards,

Steve Sheflin
Reply With Quote
  #3  
Old 21st August 2005, 19:45
SES's Avatar
SES SES is offline
Senior Member
 
Join Date: Dec 2004
Location: 05 ON LT 8
Posts: 709
SES
Re: Date convention

Hi,

This might seem like pure trivia, but I asure you it is not. The EU has - for good reasons - decided to use the YY-MM-DD format. If you tabulate data (word or exel spread-sheet) and part of it is the date, you might want to sort cronologically. Unless the above format is used you'll get complete rubbish, like 05 SEP 1944 after 04 FEB 2005. So lets stick to the computer logic format.
bregds
SES
Reply With Quote
  #4  
Old 21st August 2005, 20:08
Nick Beale's Avatar
Nick Beale Nick Beale is offline
Super Moderator
 
Join Date: Dec 2004
Location: Exeter, England
Posts: 5,839
Nick Beale has a spectacular aura aboutNick Beale has a spectacular aura aboutNick Beale has a spectacular aura about
Re: Date convention

The points about using a format to suit a database are well taken (as I eventually learned when working on a book that was stored as about 250 files named for dates!)

However, when talking about the Luftwaffe, I think there's an argument for using the format they normally used: DD MM YY. We Europeans understand it at least!
__________________
Nick Beale
http://www.ghostbombers.com
Reply With Quote
  #5  
Old 21st August 2005, 20:31
ArtieBob ArtieBob is offline
Senior Member
 
Join Date: Dec 2004
Location: Sharps Chapel, TN USA
Posts: 442
ArtieBob will become famous soon enough
Re: Date convention

There are several date conventions that are valid depending where you live and work. It is really a hassle to switch from one convention that you use most of the time to another, just for a single specific purpose (i.e. TOCH) and it leads to errors. What I suggest is use whatever convention you are familiar with, except insert three charater alpha abreviations for the month, that pretty well eliminates the confusion factor.

As for data bases and spreadsheets, I personally use three fields for dates, this lets me insert multiple day, day-night, seasons, early, late, or months without days. Otherwise programs tend to convert dates to data sets somewhat innaccurately.

Best regards

Artie Bob
Reply With Quote
  #6  
Old 22nd August 2005, 00:45
Franek Grabowski Franek Grabowski is offline
Alter Hase
 
Join Date: Dec 2004
Location: Warsaw, Poland
Posts: 2,365
Franek Grabowski is on a distinguished road
Re: Date convention

Oh, all the mess is done by Americans with their reversed month/day system. Anybody else uses it?
Reply With Quote
  #7  
Old 22nd August 2005, 01:01
Andy Fletcher's Avatar
Andy Fletcher Andy Fletcher is offline
Senior Member
 
Join Date: Dec 2004
Location: Cork, Ireland
Posts: 771
Andy Fletcher
Re: Date convention

Quote:
Originally Posted by John Beaman
Guys:

When mentioning a date, let's all use the convention like 20-Aug-05 rather than 05-08-05. With people from all over the world coming to this site, that last reference could be August 5th or May 8th.

Thanks
I think what John says makes sense, there is no ambiguity with 20-Aug-05, everyone understands it.

The format you then wish to use on your own database is entirely up to you, ie DD-MM-YY for Europeans and MM-DD-YY for Americans, which ever you find easier to use.

Regards

Andy Fletcher
Reply With Quote
  #8  
Old 22nd August 2005, 09:45
Tony Williams Tony Williams is offline
Member
 
Join Date: Dec 2004
Location: UK
Posts: 92
Tony Williams
Re: Date convention

I agree that numerical dates can cause confusion. Here in the UK '9/11/2001' means 9th November...

Using abbreviations for months (such as Aug) prevents that, but it is language-specific, which numbers are not.

Tony Williams: Military gun and ammunition website and discussion forum
Reply With Quote
  #9  
Old 22nd August 2005, 14:44
Jim P. Jim P. is offline
Alter Hase
 
Join Date: Dec 2004
Posts: 1,968
Jim P. will become famous soon enough
Re: Date convention

I use the date format suggested by John with my db files. No problems whatsoever sorting. That may depend upon the date setting one uses in Windows, but Access handles it just fine.
Reply With Quote
  #10  
Old 22nd August 2005, 16:28
Andy Fletcher's Avatar
Andy Fletcher Andy Fletcher is offline
Senior Member
 
Join Date: Dec 2004
Location: Cork, Ireland
Posts: 771
Andy Fletcher
Re: Date convention

Like Jim P I have never had any problem sorting dates with access provided they are entered as dates (the data field set to date) and not entered as plain text which does create problems when filtering and sorting.

Also when the date is entered as a date (and not a text string) then you can adjust the date format to whatever you like and it automatically updates the format of every date in the field.

Regards

Andy Fletcher
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Luftwaffe P51 shot down by US P47 ? Alex Smart Luftwaffe and Axis Air Forces 24 27th November 2015 13:09
Me 262 Production Log release date? edwest Books and Magazines 50 11th December 2005 09:26
Looking for date and place of birth rob van den nieuwendijk Luftwaffe and Axis Air Forces 0 7th April 2005 18:28
Book: Me 262 Production Log release date? edwest Books and Magazines 3 5th March 2005 02:04
Publ. date for Junkers Flugtriebwerke by Müller, R Huib Ottens Luftwaffe and Axis Air Forces 0 5th January 2005 23:12


All times are GMT +2. The time now is 14:41.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2018, 12oclockhigh.net