Results 1 to 3 of 3

Thread: Dates

  1. #1
    rel Guest

    Default Dates

    In my database i have the date and time stored using the now function. How can pull records out that were 'opened' on a certain day ignoring the time part of the date?

  2. #2
    Join Date
    Dec 1969

    Default RE: Dates

    format the date to short date<BR><BR>formatdatetime(date, vbshortdate)

  3. #3
    rel Guest

    Default RE: Dates

    LogQuery =" SELECT * FROM Log WHERE TimeOpened = #02/02/01#"<BR>i need to store both the time and date. Where do i use this function? I tried using the formatedatetime function like so LogQuery =" SELECT * FROM Log WHERE formatdatetime(TimeOpened, vbshortdate) = #02/02/01#"<BR><BR>but needless to day it didn&#039;t work!<BR>

Posting Permissions

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