I am looking for some code that will always return the week ending date. The code will open a form for the current week. I tried the Week ID but ran into problem with the year change over. The code will than be passed into a text to set the max date for the data and the min date will be six days before. I hope this makes sense.