Access 2007 - Report between 2 dates?

[burrelly]

I have a time keeping table has login and log out dates and time. What I want to do is when from a form I click a report button it opens up but only shows the data from the week we are in.

Any idea how I can do this?

 

[pbaldy]

You should find some helpful functions here:

http://www.pacificdb.com.au/MVP/Code/Dates.htm

 

[burrelly]

page not found

 

[RuralGuy]

Paul,
Graham revised his site and now things are a little different to locate. I used to use his old page all of the time too.
http://www.pacificdb.com.au/Support/code_datetime.htm

 

[pbaldy]

Thanks RG; that's what I get for just copying the bookmark without actually going to the page.

 

[burrelly]

Thanks for the link but I am not sure what bit applys to what im trying to do. Im a bit of a newbie

 

[pbaldy]

Somewhere in there you should find functions that will return the first day of the current week and the last day of the current week. You can use those in your query to have it always return the current week's data.

 

[RuralGuy]

These look like functions I copied from a response of yours Paul.

Function getWeekBegin(pDate As Date) As Date
'-- convert pDate to the previous Monday's Date
getWeekBegin = DateAdd("d", 1 - Weekday(pDate, vbMonday), pDate)

End Function

Function getWeekEnd(pDate As Date) As Date
'-- convert pDate to the next Sunday's Date
getWeekEnd = DateAdd("d", 7 - Weekday(pDate, vbMonday), pDate)

End Function