Running avg dates

I have the following formula that figures a daily avg and breaks by week.  I am pretty much a novice compared to most out on this forum and new to using this forum.  I had a post and can not locate it again.  Anyway I am trying to also use this to figure the daily average and have it break by month, quarter & year to date.  I thought I could use this same premise but I am not able to figure it out.

=DAvg(" [Occpncy Rate(Skill Level)] ","[Non SG w/ Transfers Daily QRY]","Date Between #" & DateAdd("d",-Weekday([Date],vbMonday),[Date]) & "# AND #" & [Date] & "#")

Thanks for any help.

I got it fugured out.  I had additional info place in the date functions, then what needed to be there.

=DAvg(" [Occpncy Rate(Skill Level)] ","[Non SG w/ Transfers Daily QRY]","Date Between #" & DateAdd("q",-1([Date]) & "# AND #" & [Date] & "#")  This ended up to provide the quarter results.

=DAvg("[Strght Avg Abdn%] ","[Non SG w/ Transfers Daily QRY]","Date Between #" & DateAdd("m",-Month([Date]),[Date]) & "# AND #" & [Date] & "#") This was for the month results.