If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Mask-Change to Date/Time Format
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! |
#2
|
|||
|
|||
Input Mask-Change to Date/Time Format
Use the Date() function.
-- Marin Kostov Microsoft Office XP Master Instructor |
#3
|
|||
|
|||
Input Mask-Change to Date/Time Format
On Tue, 27 Apr 2004 10:31:19 -0700, "DD"
wrote: 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. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|