Input Mask-Change to Date/Time Format

[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!

 

[Marin Kostov]

Use the Date() function.

 

[John Vinson]

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!

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.