|
Luftwaffe and Axis Air Forces Please use this forum to discuss the German Luftwaffe and the Air Forces of its Allies. |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
||||
|
||||
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 |
#4
|
||||
|
||||
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! |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Re: Date convention
Oh, all the mess is done by Americans with their reversed month/day system. Anybody else uses it?
|
#7
|
||||
|
||||
Re: Date convention
Quote:
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 |
#8
|
|||
|
|||
Re: Date convention
|
#9
|
|||
|
|||
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.
|
#10
|
||||
|
||||
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 |
|
|
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 |