Calculating End-of-Week Date

[dcornett63]

My database is used to track employees' leave balances. Our week ends at
11:59 PM on Friday. I need to know what formula to enter into my query to
return that Friday (End-of-Week) date of the week that the leave time was
taken.

Example

LvDate - 2/19/2009
EOWDate - 2/20/2009

Please help
Thanks,
David

 

[Jack Cannon]

This should do the job.

MyFridayDate: Date()+7-Weekday(Date(),7)

Jack Cannon

 

[Jack Cannon]

David

Let me modify it a little to better fit your application within your query.

EOWDate: [LvDate]+7-Weekday([LvDate],7)

Jack Cannon

 

[dcornett63]

Thanks Jack, I had actually figured it out from your first response. Works
great.
Thanks again
David

David

Let me modify it a little to better fit your application within your query.

EOWDate: [LvDate]+7-Weekday([LvDate],7)

Jack Cannon

This should do the job.

MyFridayDate: Date()+7-Weekday(Date(),7)

Jack Cannon