Input Mask-Change to Date/Time Format

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

I have a date/time field in a table for which the format
is general date. The default value is Now() which returns
for example 4/27/2004 12:31:10 PM. How can I change the
format of this field to produce these results minus the
seconds? Thanks in advance!
 
I have a date/time field in a table for which the format
is general date. The default value is Now() which returns
for example 4/27/2004 12:31:10 PM. How can I change the
format of this field to produce these results minus the
seconds? Thanks in advance!
Click to expand...

Use a Format property of

mm/dd/yyyy hh:nn

instead of General Date.

Note that the time will actually be *stored* accurate to a few
milliseconds - just not displayed. So searching for a record using a
criterion of #4/27/2004 12:31# will most likely fail.
 
Back
Top