Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012

    Unanswered: Help with date format

    I aksed this question before but maybe not the right way.

    If in the Properties Box of a form I use =now() in the "Default Value" field and it returns the date and time what is needed to just return the date?

    Thanks again,

  2. #2
    Join Date
    Jun 2007
    Maitland NSW,Australia
    =date() returns date

  3. #3
    Join Date
    Jan 2012
    Thanks that worked.

    I was using =now() which would be my preference but I can't seem to find the correct code to make a query work with it. So maybe I can ask you.

    If I have multiple entries for todays date 12/4/13 but they all have different times of the day connected to the date how would I write the query to look at all the entries for todays date, 12/4/13?

    Does this make sense?

    Thanks once more,

  4. #4
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    where mydatecolumn between #12/4/2013# and #12/5/2013#

    where mydatecolumn between #12/4/2013 00:00:00# and #12/4/2013 23:59:59#

    or as Access is US fixated
    where mydatecolumn between #12/4/2013 00:00:00 AM# and #12/4/2013 11:59:59 PM#
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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