Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: first listed date of month

    Hello!

    I want to query the first trading date of the month in my Access database. It isn't always the first, often the second or third. The dates listed are trading dates, not calendar dates, so I cannot use DateDiff and DateAdd stuff to compute the first date. I would like it to be something simple like just Day([TradeDate])= and then the first date listed for any given month.

    Any suggestions?!?!

    Best regards,

    Taher.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Link

    http://www.mvps.org/access/datetime/index.html

    Try the above link, may have what you are looking for.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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