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

    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:

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

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

    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