Thread: Date convention
View Single Post
  #5  
Old 21st August 2005, 21:31
ArtieBob ArtieBob is offline
Senior Member
 
Join Date: Dec 2004
Location: Sharps Chapel, TN USA
Posts: 449
ArtieBob will become famous soon enoughArtieBob 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