Click here to Skip to main content
15,912,578 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: iFrame question Pin
theJazzyBrain11-Jun-04 8:17
theJazzyBrain11-Jun-04 8:17 
GeneralTABLES IN SQL SERVER Pin
Brendan Vogt8-Jun-04 23:33
Brendan Vogt8-Jun-04 23:33 
GeneralRe: TABLES IN SQL SERVER Pin
Andrew Quinn AUS9-Jun-04 0:58
Andrew Quinn AUS9-Jun-04 0:58 
General<div> centering table problem Pin
CIMS/ARMS8-Jun-04 8:47
CIMS/ARMS8-Jun-04 8:47 
General<div> centering table problem Pin
CIMS/ARMS8-Jun-04 8:46
CIMS/ARMS8-Jun-04 8:46 
GeneralRe: <div> centering table problem Pin
Aaron Eldreth8-Jun-04 10:10
Aaron Eldreth8-Jun-04 10:10 
GeneralRe: <div> centering table problem Pin
woo doc, the docta woo8-Jun-04 10:34
susswoo doc, the docta woo8-Jun-04 10:34 
GeneralDate Comparision, Javascript Pin
b1azesk8-Jun-04 5:11
b1azesk8-Jun-04 5:11 
Hi folks,

I'm having a heck of a time trying to get this problem fixed. Here are the details.

We have a form that users enter date and time information into. The first field is receive date (mm/dd/yyyy and 2400 hour formats), the second field is the resolve date (mm/dd/yyyy and 24 hour format). What we do from here is compare them and get various information. Such as work time, total problem time, and stand by time. We also attempt to count each day as an 8 hour work day by getting rid of 16 hours per day.

I can get my math to work for a single month, but when the month changes (ie- 05/31/2004 for receive time and 06/01/2004 for resolve time) I get a negative value. Now the way my code is written, this is correct...the problem is that I need it to show as 8 hours TPT and not -520.

Any ideas how this might be corrected???

Here is the code:
<br />
function dateDiff(dateform) {<br />
date1 = new Date();<br />
date2 = new Date();<br />
date3 = new Date();<br />
date4 = new Date();//Received Date<br />
date5 = new Date();//Resolved Date<br />
//date6 = new Date();//Received Month<br />
//date7 = new Date();//Resolved Month<br />
fdayofour = 1072933200000;<br />
diff  = new Date();<br />
<br />
if (isValidDate(dateform.ReceiveDate.value) && isValidTime(dateform.ReceiveTime.value)) { // Validates first date <br />
date1temp = new Date(dateform.ReceiveDate.value + " " + dateform.ReceiveTime.value);<br />
date1.setTime(date1temp.getTime());<br />
}<br />
else return false; // otherwise exits<br />
<br />
if (isValidDate(dateform.ResolveDate.value) && isValidTime(dateform.ResolveTime.value)) { // Validates second date <br />
date2temp = new Date(dateform.ResolveDate.value + " " + dateform.ResolveTime.value);<br />
date2.setTime(date2temp.getTime());<br />
}<br />
else return false; // otherwise exits<br />
<br />
if (isValidDate(dateform.CurrentDate.value) && isValidTime(dateform.CurrentTime.value)) { // Validates first date <br />
date3temp = new Date(dateform.CurrentDate.value + " " + dateform.CurrentTime.value);<br />
date3.setTime(date3temp.getTime());<br />
}<br />
else return false; // otherwise exits<br />
<br />
if (date2temp < date1temp){<br />
alert("Date/Time Received cannot be greater than Date/Time Resolved");<br />
return false;<br />
} else if (date2temp>date3temp || date1temp>date3temp){<br />
		alert("Date/Time Received/Resolved cannot be greater than the Current Date/Time");<br />
		return false;<br />
} else; // otherwise exits<br />
// sets difference date to difference of second date and first date<br />
<br />
date4temp = new Date(dateform.ReceiveDate.value);//this gets the date from the received date field for the received date<br />
date4.setTime(date4temp.getDate());<br />
<br />
rdate = date4temp.getDate();<br />
<br />
date5temp = new Date(dateform.ResolveDate.value);//this gets the date from the resovled date field for the completed date<br />
date5.setTime(date5temp.getDate());<br />
<br />
rsdate = date5temp.getDate();<br />
//alert(rsdate)<br />
<br />
/*date6temp = new Date(dateform.ReceiveDate.value);//this gets the date from the received month field for the received date<br />
date6.setTime(date6temp.getMonth());<br />
<br />
rmonth = date6temp.getMonth();<br />
<br />
date7temp = new Date(dateform.ResolveDate.value);//this gets the date from the resovled month field for the completed date<br />
date7.setTime(date7temp.getMonth());<br />
<br />
rsmonth = date7temp.getMonth();<br />
//alert(rsmonth)*/<br />
/*rsall = (date2.getTime());<br />
rsall = (rsall / (1000 * 60 * 60 *24));<br />
rall = (date1.getTime());<br />
rall = (rall / (1000 * 60 * 60 *24));*/<br />
rsall = (date2.getTime() - fdayofour);<br />
rall = (date1.getTime() - fdayofour);<br />
rdate = ((rsall - rall) / (1000 * 60 * 60));<br />
<br />
diff.setTime(date2.getTime() - date1.getTime());<br />
<br />
timediff = diff.getTime();<br />
dtimediff = diff.getTime();<br />
mtimediff = diff.getTime();<br />
<br />
//condtime = Math.floor(condtime);<br />
days = (dtimediff / (1000 * 60 * 60 * 24));<br />
days = Math.floor(days);<br />
//days = (days * 16);<br />
<br />
totdate = (rsdate - rdate);<br />
if (totdate >= 0){<br />
	totdate = (totdate * 16);<br />
	} else if (totdate < 0){<br />
	totdate = (Math.round(days * 16))<br />
	}<br />
mins = (mtimediff / (1000 * 60));<br />
//hours = (timediff / (1000 * 60 * 60));<br />
hours = (mins / 60);<br />
hours = (hours - totdate);<br />
//alert(("rest " + rsall) + (" rec " + rall));<br />
alert(rdate);<br />
worktime =  Math.round((dateform.WorkTime.value * 10) /10);<br />
totalproblemtime = Math.round((hours * 10) /10);<br />
standbytime = totalproblemtime - worktime;<br />
standbytime = Math.round(standbytime *10)/10;<br />
dateform.WorkTime.value = worktime;<br />
dateform.StandByTime.value = standbytime;<br />
dateform.TotalProblemTime.value = totalproblemtime;<br />
return false; // form should never submit, returns false<br />
}<br />
<br />

GeneralRe: Date Comparision, Javascript Pin
Andrew Quinn AUS8-Jun-04 5:29
Andrew Quinn AUS8-Jun-04 5:29 
GeneralRe: Date Comparision, Javascript Pin
b1azesk8-Jun-04 5:34
b1azesk8-Jun-04 5:34 
GeneralRe: Date Comparision, Javascript Pin
Richard Deeming17-Jun-04 8:18
mveRichard Deeming17-Jun-04 8:18 
GeneralLive Chat application problem Pin
satyav8-Jun-04 3:50
satyav8-Jun-04 3:50 
GeneralData missing Pin
satyav8-Jun-04 3:49
satyav8-Jun-04 3:49 
Generalmultiple login in an asp application Pin
Imran Majeed7-Jun-04 21:09
Imran Majeed7-Jun-04 21:09 
GeneralRe: multiple login in an asp application Pin
Hesham Amin7-Jun-04 21:45
Hesham Amin7-Jun-04 21:45 
GeneralRe: multiple login in an asp application Pin
palbano8-Jun-04 8:18
palbano8-Jun-04 8:18 
GeneralRe: multiple login in an asp application Pin
Hesham Amin8-Jun-04 21:16
Hesham Amin8-Jun-04 21:16 
GeneralRe: multiple login in an asp application Pin
Member 12016744-Jul-04 8:18
Member 12016744-Jul-04 8:18 
GeneralRe: multiple login in an asp application Pin
Member 12016744-Jul-04 8:24
Member 12016744-Jul-04 8:24 
Generalhi Pin
Anonymous7-Jun-04 20:24
Anonymous7-Jun-04 20:24 
Generalhmmm Pin
brianwelsch9-Jun-04 11:58
brianwelsch9-Jun-04 11:58 
GeneralRe: hi Pin
Aaron Eldreth9-Jun-04 13:40
Aaron Eldreth9-Jun-04 13:40 
Generaltake a look Pin
Anonymous7-Jun-04 20:19
Anonymous7-Jun-04 20:19 
Generaltake a look Pin
Anonymous7-Jun-04 20:18
Anonymous7-Jun-04 20:18 
GeneralBig problem suffering from week Pin
IamADotNetGuy7-Jun-04 13:05
IamADotNetGuy7-Jun-04 13:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.