Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Unanswered: Checking if date is the 1st Friday of the month

    Need code to check if a date is the 1st Friday of the month. I intend to incorporate this into my multiple IIf's statements in a Text box in one of my reports.

    Appreciate all your suggestions!

  2. #2
    Join Date
    Nov 2002
    Posts
    150
    The first Friday of the month will always be the 6th or less.

  3. #3
    Join Date
    Jan 2003
    Posts
    5
    Originally posted by FirstAndGoal4
    The first Friday of the month will always be the 6th or less.
    I understand that. That being the case, how should the IIF statement look like? Sorry, but I'm still learning my way thru Access so I'd appreciate if you could be more elaborate.

  4. #4
    Join Date
    Nov 2002
    Posts
    150
    Originally posted by jchav
    I understand that. That being the case, how should the IIF statement look like? Sorry, but I'm still learning my way thru Access so I'd appreciate if you could be more elaborate.
    Sorry....

    iif(weekday(datetocheck) = 6, iif(day(datetocheck) <= 6, true, false), false)

Posting Permissions

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