p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   MS SQL 2000 & ASP (http://p2p.wrox.com/showthread.php?t=31710)

Adam H-W July 21st, 2005 02:51 AM

MS SQL 2000 & ASP
Hi there

I've built an admin area where the person can input a date into a field. On the output page I need to determine when one month starts and another one ends so that I can have a header to each month - July or August etc.

Is it possible for sql/asp to determine when one month ends and another one starts? If so, how can I go about it?!

thanks in anticipation


happygv July 22nd, 2005 02:13 PM

Hi Adam,

Is that you wanted to find whats the last date of every month?
Not sure what you are looking for. Can you explain it in details?

- Vijay G
Strive for Perfection

Adam H-W July 25th, 2005 11:21 AM


Just wanted to be able to put a month header at the top of the relevnant month - i.e where August starts, I'd like to put a header of AUGUST before any dates in August.

Many thanks


askenkray August 22nd, 2005 07:58 AM

you can use the monthname property in ASP to find the name of the month.I hope that this will solve your problem.

Ashwin S.Kenkare

All times are GMT -4. The time now is 07:21 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.