First & Last Date of Current Week


to Get the first & last Date of Current week using MS ACCESS

first & Last Day of Current Week



Hello developers

sometimes we are working with dates using database , here i give a example to get the first & last day of week from MS Access database

1. Get First day of Week


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


and

2. Get Last day of Week


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


Related Articles

More articles: Last day of Week First day of Week MS Access

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: