|
Re: date format
Mr. "Swamped with work" coming up for air - between changing positions within my medical facility and converting to a whole new HIS system because we were purchased by another hospital organization, I have been swamped with work - but that's my problem.
Anyway - I've been using MS Access for years (now at Access 2010). When setting up an Access table date field the format can be defined. In my case I set the format to 'Medium Date'. When I type something like 1-4-44 it will convert to 1-Apr-44 or if I type in 4-30-44 it also converts to 30-Apr-44, but in this last instance the first number has to be greater than 12. If not the program interprets the first number as the month. MS Access is only included with MS Office Pro I think.
Which leaves most MS Office users with Excel. Excel does allow for something similar within the definition of a column of cells, although since I don't use it except for exporting files, I'm not totally familiar all characteristics of date formatting within Excel (which I hate as far tabulating table data BTW - sorting is a pain in the a@@ for one major reason).
Bottom line is that if dates appear in a format such as '1-Apr-44' in any posts any confusion is totally eliminated. Just sayin' from my point of view.
|