"Week Ending" formula

I have a database with a date field, and would like my query to calculate the week ending
date of each record from that date field, but I can't find the formula.

Thanks much,

Michael M Murphree
SAGEMAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
deightonConnect With a Mentor Commented:
If you want the week ending to fall on Friday where your daye field is [date_field] then use

[end_week] = [date_field] + (7 - Weekday([date_field],7))

Hope this works
0
All Courses

From novice to tech pro — start learning today.