Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Fields (XP)

    I have a table that I enter dates into and I use the date field as the basis of a query. My date field seems to be storing not only the date mm/dd/yyyy but also the time, which I don't want. I have the field set to short date. What should I actually be doing to eliminate time from being stored in the field?

    Thanks again to all the great Access gurus!

  2. #2
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Fields (XP)

    I think I just figured out my problem. I had a default value of NOW() rather than DATE() and thus the time was put in.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •