Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Red face Unanswered: Date is helllllllllllllllll

    Hi Folks,

    I am facing all sorts of problem using date.
    I have field which is having date and time stored in it and i want to fetch records just based on the date not the time at a particular scenario.

    To fetch records i have to supply next date to fetch proper records.

    Is there any standarad ways to avoid these kinda sistuations.

    Hoping for quick reply and thanx in advance

    regards
    Sree

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please show your query, show a few sample rows from the table, and explain what results the query should produce

    rudy

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    please show your query, show a few sample rows from the table, and explain what results the query should produce

    rudy
    Thank you.


    Also, the general syntax for checking by date only would be '#yourdate#' without the quotes.

Posting Permissions

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