Format$ function

[Doug]

Just looking for the structure of the function.
I grouped a report by week =Format$([Date],"ww",0,0)
I want to display the first date of the week, can I do it
with this function or do I have to apply another function
for this.

Thanks for any help

 

[John Spencer (MVP)]

What is the first day of the week? Sunday, Monday, or some other day?


If Monday, try
DateAdd("d",1-Weekday([Date],2),[Date])

If Sunday, try
DateAdd("d",1-Weekday([Date],1),[Date])