+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, Access Query Date/Time in Technical; Hi I have a Access Database, which has a DateTime Column. The data is logged as DD/MM/YYYY HH:MM:SS When I ...
  1. #1
    linkazoid's Avatar
    Join Date
    May 2007
    Location
    London
    Posts
    644
    Thank Post
    118
    Thanked 89 Times in 73 Posts
    Rep Power
    78

    Access Query Date/Time

    Hi

    I have a Access Database, which has a DateTime Column. The data is logged as DD/MM/YYYY HH:MM:SS

    When I create a query to get all data for today's date, Date() it does not show anything. Is there a way I can split this data so I can just get todays date?

    Sorry if it doen't make sense...

    Michael

  2. #2
    tinmanjo's Avatar
    Join Date
    Mar 2010
    Posts
    16
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I think you mean Now(), this gives the current system time and date.

  3. #3

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    Date() works for me on a date column but I separate date and time into different fields

  4. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Date() should work, what does your query look like?

  5. #5

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,403
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    The query is comparing the whole date/time combo.

    If you use Format([datefield],"dd/mm/yy") for the column value and Format(Date(),"dd/mm/yy") for the criteria then you will be able to find matches for the system date.
    Last edited by CESIL; 18th March 2010 at 04:38 PM.

  6. #6
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Quote Originally Posted by CESIL View Post
    The query is comparing the whole date/time combo.
    LOL good point..

SHARE:
+ Post New Thread

Similar Threads

  1. Full time and Date to Unix format
    By danIT in forum Coding
    Replies: 9
    Last Post: 28th June 2009, 11:37 PM
  2. HP 4108GL Time and Date
    By DAckroyd in forum Hardware
    Replies: 4
    Last Post: 10th March 2009, 03:59 PM
  3. Access - Date Query
    By garethedmondson in forum Office Software
    Replies: 12
    Last Post: 29th January 2009, 09:14 PM
  4. [CLOSED] Bug/Error: Date/Time is wrong.
    By contink in forum EduGeek.net Site Problems
    Replies: 2
    Last Post: 3rd March 2008, 02:44 PM
  5. Query AD on object created date
    By KarlGoddard in forum Windows
    Replies: 3
    Last Post: 15th February 2006, 12:14 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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