[AccessD] Weekending Date

Paul, try

dtNextSunday = dtDate + 7 - Weekday(dtDate,vbmonday)


Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> paul.hartland at fsmail.net
> Sent: 01 April 2003 09:21
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Weekending Date
> 
> 
> To all,
> 
> I just can't think straight today (as usual), I want the user 
> to be able to click a button and the Weekending date to be 
> calculated...
> 
> i.e.
> 
> User clicks today (01/04/03) and the weekending date displays 
> as 06/04/03..
> 
> Whats the best way to do this, the weekending date will 
> always be the following Sunday, unless it is Sunday of course..
> 
> Paul
> 
> ______________________________________________________________
> ____________
> Join Freeserve http://www.freeserve.com/time/
> 
> Winner of the 2003 Internet Service Providers' Association 
> awards for Best Unmetered ISP and Best Consumer Application.
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>