Get first & last Date of Current week in MS ACCESS

Getting first day of week


select DateAdd('d', -DatePart('w','" + DateTime.Now.ToString("MM/dd/yyyy") + "', 1) +1,'" + DateTime.Now.ToString("MM/dd/yyyy") + "')

Getting last day of week

select DateAdd('d', -DatePart('w','" + DateTime.Now.ToString("MM/dd/yyyy") + "', 1) +5,'" + DateTime.Now.ToString("MM/dd/yyyy") + "')";


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: