Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dates in query (2003 SP2)

    I am getting some funny results when using dates in a query, run from code.

    USDateFOrmat =
    Regards,
    Peter

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: dates in query (2003 SP2)

    Do you really need the times, or are you only concerned with dates?

    I just this date format
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dates in query (2003 SP2)

    Times are required. Already tried formatting without time (even though I do need times); same result though.
    Regards,
    Peter

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: dates in query (2003 SP2)

    Does the query qryEmailMeetHelpers also have each the date fields formatted in the format "mmm/dd/yyyy hh:nn:ss AM/PM" ?
    Regards
    John



  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dates in query (2003 SP2)

    It does now! Works a treat.
    Thanks John.
    Boy I bet it's cold up where you are today.
    Regards,
    Peter

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: dates in query (2003 SP2)

    Good, I am glad that fixed it.

    Yes, it is cold. We had a few flurries of snow this morning.
    Regards
    John



Posting Permissions

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