Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Does anyone know of???

Author  Topic 

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2007-11-11 : 18:34:32
I would like to have a simple web based calendar that I can connect to a database that will...

looking at the current date (ie 11/11/2007) and display the current month (in this example November) then

go through a database and evaluate 1 field (ship by - date field), this field may have many occurences of 11/11/2007 as well as other dates.

count how many 11/11/2007's exist in the field

based on the number of occurences display the calendar day 11/11/2007 as:

green if >=0 and <=50
yellow if >50 and <75
red if >75

This would be done for every day in Novemeber, it would be nice to have controls that can switch to a different month displaying the same info for that month also. I only need to display 1 month at a time.

Anyone knowing of a calendar that can do this?

Thanx

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2007-11-11 : 18:57:25
You can either create a calendar control, or use a built in calendar control from within the existing libraries. The code behind what you ask would have to be written as there likely isn't one that exists with exactly your criteria.

WHy did you post this twice? I am sure the duplicate will get locked at some point.



Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2007-11-12 : 14:37:28
thanx for the info,

Sorry for the duplicate, didn't think the first one saved and then changed my mind on where to post.

Sorry again...
Go to Top of Page
   

- Advertisement -