Since we are talking about datetime I need some info. A couple of months ago I started having some issues on some tables and the blues clues led me to find out that it was a datetime issue. All my tables have a datetime stamp. At the time I changed the format to HH:MM ap from HH:MM:SS and all was fine. Now I find out from one of my locations that the employees time sheet is not working properly. first thing I checked was the time format and it was HH:MM ap, looking further I find the time seq is hhmmss. If I change both to the same either HH:MM:SS and hhmmss, or HH:MM ap and hhmm they will both work. My question is which is the proper way?
Tom Hart
