Format$ function

  • Thread starter Thread starter Doug
  • Start date Start date
D

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
 
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])
 
Back
Top