Calculating End-of-Week Date

  • Thread starter Thread starter dcornett63
  • Start date Start date
D

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
 
David

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

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

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

Jack Cannon said:
David

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

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

Jack Cannon

Jack Cannon said:
This should do the job.

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

Jack Cannon
Click to expand...
Click to expand...
 
Back
Top