Database

CleaKO wrote:

I think it defaults to 30 seconds.

Mr.Kode wrote:

i want code to let the user specify their ID and password anf verfiy passwords to enter the application

DateTime start = new DateTime(2007, 1, 1);
int num = 0;
while (DateTime.Compare(DateTime.Today, start) == 1)
{
    int day = (int)start.DayOfWeek;
    if (day > 0 && day < 6)
        num++;
    start = start.AddDays(1);
}

SELECT DATEDIFF (dd, '01/01/2007',getdate()) - (DATEDIFF (wk, '01/01/2007',getdate()) * 2)

CREATE function dbo.DateDiffWeekdays
(@fromdate datetime,
@todate datetime)
RETURNS int
AS 
begin
declare @procdate datetime, @enddate datetime
declare @weekdays int
set @procdate = @fromdate 
set @weekdays = 0

while (@procdate < @todate) 
begin
if (datepart(dw, @procdate + 1) <> 1) and (datepart(dw, @procdate + 1) <> 7)
set @weekdays = @weekdays + 1
set @procdate = dateadd(d, 1, @procdate)

end
---
if @todate is null 
set @weekdays = null

return @weekdays
end

CREATE FUNCTION WeekDaysBetween
(
@from datetime,
@to datetime
)
AS
BEGIN
DECLARE @num int
SET @num = 0
WHILE (DATEDIFF(day, @from, @to) > 0)
BEGIN
   DECLARE @day int
   SET @day = DATEPART(dw, @from)
   IF (@day > 1 AND @day < 7)
	SET @num = @num + 1
   SET @from = DATEADD(day,1 , @from)
END
RETURN @num
END