Date and Time Format/Input Mask 1

[bddewell408]

The following is a input mask I was able to create :

99/99/0000\ 00:00;0;_

This allows for a user to type in the date and military time, very useful for projects involving time accounting especially when one shift starts on one calendar date and ends on the next etc. Also, I created an unbound field and used the expression builder to calculate the number of hours worked using two fields named [dtmBeginDateandTime] and [dtmEndDateandTime]

THE PROBLEM : the input mask holds spaces for (ex.) 01/01/2004 1300, yet when enter is struck changes it to 1/1/2004 1300. I want the database to hold the 01/01/2004 1300 format. I have tried all of the various long medium etc formats, but I am not familiar enough with formats and input criteria.

Any help is mucho appreciated.
Bryan

 

[Golom]

DateTime values are not stored with any particular format. You can open the table in design view and enter mm/dd/yyyy hhnn as the format of the datetime field. it will then display as 01/01/2004 1300

 

[bddewell408]

THANKK YOU, THANK YOU, THANK YOU!!!!