Weekend Date Code??

[zrazzaq]

Hi:
Does anyone know how in vb to automatically pick the weekend date automatically depending upon the date of the transaction?
For example:
My week goes from Monday-Sunday, so Sunday would be my weekend date:
Hence:
1/2/2006-1/8/2006
My weekend date is 1/8/2006.
So the report would do automatically 1/8/2006 week transactions and then so on.
Thanks
Zishan

 

[PHV]

A starting point:
dtWeekEnd = dtTransaction + 7 - Weekday(dtTransaction, vbMonday)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886