Query - Formula needed to set it for a week date

[reddd]

Hi there,
I'm super glad to have found you all!
I am looking for a query much like this one -
Date()-Weekday(Date(),2)-56

I don't want it to be all the dates inside the 56. I just need the query to pull the Sunday from 13 weeks ago date data. Can that happen? I have a lot of different queries that need this info so I don't want to have to do this manually every time I pull a report on this.

Thanks for your help!
Reddd

 

[Joe4]

Welcome to the Board!

So, for today, would you want it to return June 10, 2018, or June 17, 2018?
You would just need to change the 56 (which represents 8 weeks) in your formula above to 91 (13 weeks) or 84 (12 weeks).

 

[mole999]

try
=TODAY()-(WEEKDAY(TODAY(),2)+91)

 

[welshgasman]

Create a function to return the date. I'll use your code to calculate the Sunday date, but change it if it does not produce what you want

Public Function Sunday13() As date
Sunday13 = Date()-Weekday(Date(),2)-56
End Function

Then just call it from anywhere.

 

[Joe4]

try
=TODAY()-(WEEKDAY(TODAY(),2)+91)

TODAY() is a not a valid function in Access.
(guessing you didn't realize you were in the Access forum)

 

[mole999]

TODAY() is a not a valid function in Access.
(guessing you didn't realize you were in the Access forum)

I miss it every time , read the question, not the location

 

[reddd]

Create a function to return the date. I'll use your code to calculate the Sunday date, but change it if it does not produce what you want

Public Function Sunday13() As date
Sunday13 = Date()-Weekday(Date(),2)-56
End Function

Then just call it from anywhere.

THIS WORKS!
=Date()-Weekday(Date(),2)-91

Thank you! Thank you! Thank you for your help!

 

[Joe4]

THIS WORKS!
=Date()-Weekday(Date(),2)-91

That is what I was telling you to do up in the first reply (just change the 56 to 91), and even explained why!