Results 1 to 4 of 4

Thread: *RESOLVED* Given a date return the date of Monday the same week

Threaded View

  1. Jul 7th, 2002, 07:46 PM #1
    cafeenman
    cafeenman is offline

    Thread Starter
    PowerPoster cafeenman's Avatar
    Join Date
    Mar 2002
    Location
    Florida
    Posts
    2,819

    *RESOLVED* Given a date return the date of Monday the same week

    I'm stumped. The title says it all.

    I need the date of Monday for the same week as any date entered. I'm using the system settings for the first day of week.

    For some reason I can get it to work unless the day selected is the first day of the week. In that case it always selects the monday of the previous week. For all other dates it works fine.

    VB Code:
    1. dMonday = DateAdd("d", -Weekday(dSelectedDate, vbMonday) + 1, dSelectedDate)
    Last edited by cafeenman; Jul 7th, 2002 at 08:06 PM.
    Airfield Models
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width