ASP/SQL Week start

Capodecina
Permabanned
Joined
31 Dec 2003
Posts
5,172
Location
Barrow-In-Furness
Is there any way I can display data in a weekly format?

I would like to display data for a given week, starting from Monday through to Sunday.

For example, Week start 05/01/07 would show all entries between the 5th and the 11th.

Also, when i'm entering the date using a textbox, i've set the format to short date but when I present entries it shows the date followed by 00:00:00, how do I stop this?

I'm coding in VB.

Cheers for any help :)
 
Last edited:
Back
Top Bottom