Results 1 to 4 of 4
  1. #1
    Trojnfn is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    46

    Date/Time question

    In my table, I have a field defined as datatype date/time. In the format, it is set to general. The date displays properly but the time does not show up. I even increasd the displayed field lenght but nothing.

    What do I do to get the time to display along with the date ?

  2. #2
    Toyman is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    233
    Quote Originally Posted by Trojnfn View Post
    In my table, I have a field defined as datatype date/time. In the format, it is set to general. The date displays properly but the time does not show up. I even increasd the displayed field lenght but nothing.

    What do I do to get the time to display along with the date ?
    Dose your data include the time? How are you entering the date/time?

  3. #3
    Trojnfn is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    46
    The date can be manually entered or selected from the calendar. No time is acutally entered. Doesn't the time default based on the data type settings ?

  4. #4
    Toyman is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    233
    Quote Originally Posted by Trojnfn View Post
    The date can be manually entered or selected from the calendar. No time is acutally entered. Doesn't the time default based on the data type settings ?
    No, how would the db know what time it is unless someone enters it or have it entered with code, etc.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Getting Just the Date part of Date/Time field
    By GaryElwood in forum Reports
    Replies: 7
    Last Post: 09-28-2011, 09:58 AM
  2. Replies: 12
    Last Post: 02-22-2011, 03:39 PM
  3. Replies: 6
    Last Post: 01-04-2011, 05:43 PM
  4. Question about Button and Time Stamp
    By euroclyde in forum Access
    Replies: 2
    Last Post: 06-16-2010, 09:01 AM
  5. Real time database question
    By joet5402 in forum Forms
    Replies: 7
    Last Post: 04-01-2009, 09:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums