Results 1 to 3 of 3

Thread: Time Question

  1. #1
    Join Date
    Jan 2003
    Posts
    56

    Red face Unanswered: Time Question

    Hi,

    How can you filter records using a date field by using Time() as a criteria? I can't seem to get it to work. Any suggestions?

    C.

  2. #2
    Join Date
    Dec 2003
    Location
    The Netherlands
    Posts
    98

    Re: Time Question

    Originally posted by coolowen
    Hi,

    How can you filter records using a date field by using Time() as a criteria? I can't seem to get it to work. Any suggestions?

    C.
    Hi,

    what exactly are you filtering for? Why do you want to use time()?
    COuld you explain a bit more about what you are looking for?

    thanks

  3. #3
    Join Date
    Jan 2003
    Posts
    56

    Re: Time Question

    Originally posted by charlottevk
    Hi,

    what exactly are you filtering for? Why do you want to use time()?
    COuld you explain a bit more about what you are looking for?

    thanks
    Hi sorry,

    I want to be able to trigger a report for customers in a video store. If the time which has been recorded initially (in a rental record) corresponds to the time settings on the computer I want a query to show only those records which have the corresponding time from the rentals. Essentially I want to filter the records based on time.

Posting Permissions

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