Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    11

    Cool Unanswered: Query to display Date from NOW to the end of the month

    I have a form that displays contacts birthdays this month and I want to make a query that shows upcoming birthdays this month. Can someone help me figure this out?

    Thanks,
    Sudney

  2. #2
    Join Date
    Jun 2004
    Posts
    6
    Try -
    Code:
    SELECT
        Employees.EmployeeID
      , Employees.LastName
      , Month([BirthDate]) AS BMonth
      , Day([birthdate]) AS BDay
    FROM
       Employees
    WHERE
       (((Month([BirthDate]))=Month(Date())) 
    AND
       ((Day([birthdate]))>=Day(Date())));
    ...modified to your table and field names.

    HTH - Bob

  3. #3
    Join Date
    Nov 2003
    Posts
    11
    Thanks it works well

    Sudney

Posting Permissions

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