Solved Pulling records based on day of the week (1 Viewer)

[sroot]

I have a query that i need to pull all records from Monday through today. I figured out how to do most of it. i tried this ">Date()-Weekday(Date()-2)" The problem i come across is when i try to run it on Monday it pulls from last Monday and i would like it to only pull today. Is there any way to do that? Thanks!

 

[Gasman]

Use IIF() to test if a Monday and adjust accordingly?

 

[theDBguy]

Just a thought but could you give this a try?

>=DateAdd("d",1-Weekday(Date(),2),Date())

 

[Gasman]

Also look at
Date()-(Weekday(Date())-2)

but test it throroughly as I would expect today to return today as the latter part returns 0?

 

[sroot]

Just a thought but could you give this a try?

>=DateAdd("d",1-Weekday(Date(),2),Date())

That works like a charm. Thank you!

 

[theDBguy]

That works like a charm. Thank you!

You're welcome. Glad to hear you got it to work. Good luck with your project.