Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Selected month/date records

    I have a table with a start date and and end date.

    For invoicing purposes I need to check that whether a record from my table should appear on a particular months invoice. I can calculate the start day of the month and the end date of the month, but I am struggling to just select the records that should appear on a specific months invoice.

    Does anyone know of a function that I can use?

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selected month/date records

    Just use the month function. If will give the a number (1-12) that represents the month of the date in question. You can then add a criteria to that find for whatever month you are looking for.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selected month/date records

    Be sure and take into account the year as well.

Posting Permissions

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