Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    4

    Unanswered: Select records where date is the last day of month

    I'm trying to find records in a table where the date is the last date of that month. For example if the record is dated 10/31/10 then it should be in my results, but if it's any other date in that month, then it should not be in my results.

    I know the code would be like this:

    Code:
    Select *
    From MyTable
    Where TransactionDate = lastdateofmonth
    What code gets the lastdateofmonth?

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Look down about 10 threads and there is someone who asked virtually the same question.
    Ken

    Maverick Software Design

    (847) 864-3600 x2

Posting Permissions

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