Query to Show Week Ending Date

[jHats]

Hello,

I am a novice with access.

I am trying to build a query that groups by Weekending date. I am able to get it group and show the week number by using the following code :

Earned Date: DatePart("ww",[TK_PULLED],2)

I want it to group the same way, but show the short date of the week ending. I have googled a lot and the info ive researched seems overly complex. Is there a simple way to slide the format function into the above code to get it to show the weekending date as what its grouped by?

TIA!

 

[jdraw]

I suggest that you google with this as search criteria
ms access week ending date
You'll find several posts from different sources.

Good luck.

 

[apr pillai]

Use the formula below to find Week-end Date:

y = #01/01/2017#
x = Date()
? y+DatePart("ww",x)*7-1

 

[apr pillai]

Date() - WeekDay(date())+7