Time Validation 2

curt62 · Feb 13, 2003

I have a Javascript validation routine that runs on a Domino web form. I need two more validations done that are giving me trouble. Here is the situation

Start Time is entered in this field ="twField0"
End Time is entered in this field = "twField4"

Times are entered in this format (hh:mm AM/PM) and the user does not have the ability to deviate from this format.

I need to check that the period between the "start time" and the "end time" does not cross midnight. If it does, throw an alert and do not allow user to continue.

I also need to check that the duration between "start time" and "end time" does not exeed 12 hours. If it does throw an alert but allow user to continue.

The data entry is occuring in a form that passes the values to the parent form so the entry form never gets submitted to the server. This is why the validation must happen within this function.

Here is the existing code that is in the JS header of the form. All of these validations are currently working fine.

function twValidateRecord(intThisRecord) {

if (window.document.forms[0].twField0.value.length==0) {alert("Date cannot be empty&quot

; return false;};

if (window.document.forms[0].twField1.value.length==0) {alert("Start Time cannot be empty&quot

; return false;};

if (window.document.forms[0].twField4.value.length==0) {alert("End Time cannot be empty&quot

; return false;};

if ((window.document.forms[0].twField3.value.length==0) && (window.document.forms[0].twField2.value.length!==0))
{alert("Need an In From lunch value&quot

; return false;};

if ((window.document.forms[0].twField2.value.length==0) && (window.document.forms[0].twField3.value.length!==0))
{alert("Need an Out to lunch value&quot

; return false;};

return true;

}

mwolf00 · Feb 13, 2003

after you validate as above...

fromTime = document.forms[0].twField0.value
toTime = document.forms[0].twField4.value

fromDate = new Date()
toDate = new Date()

fromHour = fromTime.substr(0,2)
fromMin = fromTime.substr(3,2)
fromAM = fromTime.substr(6,2)

if (fromAM == "PM&quot

{
fromHour = parseInt(fromHour) + 12
}

fromDate.setHours(fromHour)
fromDate.setMinutes(fromMin)

toHour = toTime.substr(0,2)
toMin = toTime.substr(3,2)
toAM = toTime.substr(6,2)

if (toAM == "PM&quot

{
toHour = parseInt(toHour) + 12
}

toDate.setHours(toHour)
toDate.setMinutes(toMin)

diff = toDate.getTime() - fromDate.getTime()

if (diff > (1000 * 60 * 60 *12)){
//throw error - over 12 hours
}
else if (diff < 0){
//throw error - over midnite (ends before it starts)
}
Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

jemminger · Feb 13, 2003

try this out:
[tt]
<html>
<head>
<script language="javascript">
function checkTimes(oStart, oEnd) {
if (!oStart.value || !oEnd.value) {
alert("Please enter a Start time and an End time.&quot

;
return false;
}
// times are this format (hh:mm AM/PM)
var hhStart = parseInt(oStart.value.split(" &quot

[0].split(":&quot

[0], 10);
var hhEnd = parseInt(oEnd.value.split(" &quot

[0].split(":&quot

[0], 10);
var mmStart = parseInt(oStart.value.split(" &quot

[0].split(":&quot

[1], 10);
var mmEnd = parseInt(oEnd.value.split(" &quot

[0].split(":&quot

[1], 10);

var ampmStart = oStart.value.split(" &quot

[1].toUpperCase();
var ampmEnd = oEnd.value.split(" &quot

[1].toUpperCase();

// make sure time doesn't span midnight
if (ampmStart == "PM" && hhStart < 12 && ampmEnd == "AM&quot

{
alert("Times may not span midnight.&quot

;
return false;
}

// make sure time span < 12 hours total
if (ampmStart != ampmEnd) hhEnd += 12;
if (hhEnd - hhStart > 12 || (hhEnd - hhStart == 12 && mmEnd > mmStart)) {
alert("Time span may not exceed 12 hours.&quot

;
return false;
}
}
</script>
</head>
<body>
<form>
<input type="text" name="twField0" />
<input type="text" name="twField4" />
<input type="button" name="" value="checkTimes();" onclick="checkTimes(this.form.twField0,this.form.twField4);" />
</form>
</body>
</html>

[/tt]

======================================================================
=========================================================
if (!succeed) try();
-jeff

curt62 · Feb 13, 2003

jemminger

that is a nice bit of coding there but it will still allow for a start time to be say 11:30 AM and the end time to be 12:30 AM. This would also span midnight but would not be caught.

This is a time sheet application and I have to cover all my bases or the users will surely mess it up.

jemminger · Feb 13, 2003

hmm...how about this:
[tt]
function checkTimes(oStart, oEnd) {
if (!oStart.value || !oEnd.value) {
alert("Please enter a Start time and an End time.&quot

;
return false;
}
// times are this format (hh:mm AM/PM)
var hhStart = parseInt(oStart.value.split(" &quot

[0].split(":&quot

[0], 10);
var hhEnd = parseInt(oEnd.value.split(" &quot

[0].split(":&quot

[0], 10);
var mmStart = parseInt(oStart.value.split(" &quot

[0].split(":&quot

[1], 10);
var mmEnd = parseInt(oEnd.value.split(" &quot

[0].split(":&quot

[1], 10);

var ampmStart = oStart.value.split(" &quot

[1].toUpperCase();
var ampmEnd = oEnd.value.split(" &quot

[1].toUpperCase();

if (ampmStart == "PM&quot

hhStart += 12;
if (ampmEnd == "PM&quot

hhEnd += 12;

// make sure time doesn't span midnight
if ((ampmStart == "PM" && hhStart < 12 && ampmEnd == "AM&quot

||
ampmStart == "AM" && ampmEnd == "AM" && hhStart < 12 &&
(hhEnd > 12 || (hhEnd == 12 && mmEnd > 0))) {
alert("Times may not span midnight.&quot

;
return false;
}

// make sure time span < 12 hours total
if (hhEnd - hhStart > 12 || (hhEnd - hhStart == 12 && mmEnd > mmStart)) {
alert("Time span may not exceed 12 hours.&quot

;
return false;
}
}
[/tt]
=========================================================
if (!succeed) try();
-jeff

mwolf00 · Feb 13, 2003

In my code, the 11:30 AM to 12:30 AM would throw an error because I set them on the same day - therefore the end time would occur before the start time... Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

curt62 · Feb 13, 2003

You da man...thanks

curt62 · Feb 14, 2003

mwolf00

your code is working for the most part however,I have a small problem. I need users to be able to select 12:00 AM as an end time to the shift. right now it throws the alert.
I attempted to modify your if statement to allow 12:00 AM as an end time but it won't work for me

if ((diff < 0)&&(document.forms[0].twField4.value!="12:00 AM&quot

{
{alert("Shift cannot span Midnight&quot

; return false;};
}

Also the test for being over 12 hours is giving me the alert if I enter 11:30 AM as start time and 9:30 PM as end time. Not over 12 yet it throws the alert.

Any ideas?

mwolf00 · Feb 14, 2003

// the easiest thing to do so you don't have to worry about the last day of the year is to reset "toDate" to 11:59:59:999

//after these two lines of code
toDate.setHours(toHour)
toDate.setMinutes(toMin)

//add this if statement (shave off 1 millisecond from midnight)
if (toTime == "12:00 AM&quot

{
toDate.setHours(23)
toDate.setMinutes(59)
toDate.setSeconds(59)
toDate.setMilliseconds(999)
}

//original code continues here....

diff = toDate.getTime() - fromDate.getTime()

if (diff > (1000 * 60 * 60 *12)){
//throw error - over 12 hours
}
else if (diff < 0){
//throw error - over midnite (ends before it starts)
}
Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

curt62 · Feb 14, 2003

Did what you said but still throws the alert. Here is the code. Can you see my problem.

I appreciate any light you can shed.

function twValidateRecord(intThisRecord) {

if (window.document.forms[0].twField0.value.length==0) {alert("Date cannot be empty&quot

; return false;};

if (window.document.forms[0].twField1.value.length==0) {alert("Start Time cannot be empty&quot

; return false;};

if (window.document.forms[0].twField4.value.length==0) {alert("End Time cannot be empty&quot

; return false;};

if ((window.document.forms[0].twField3.value.length==0) && (window.document.forms[0].twField2.value.length!==0))
{alert("Need an In From lunch value&quot

; return false;};

if ((window.document.forms[0].twField2.value.length==0) && (window.document.forms[0].twField3.value.length!==0))
{alert("Need an Out to lunch value&quot

; return false;};

fromTime = document.forms[0].twField1.value
toTime = document.forms[0].twField4.value

fromDate = new Date()
toDate = new Date()

fromHour = fromTime.substr(0,2)
fromMin = fromTime.substr(3,2)
fromAM = fromTime.substr(6,2)

if (fromAM == "PM&quot

{
fromHour = parseInt(fromHour) + 12
}

fromDate.setHours(fromHour)
fromDate.setMinutes(fromMin)

toHour = toTime.substr(0,2)
toMin = toTime.substr(3,2)
toAM = toTime.substr(6,2)

if (toAM == "PM&quot

{
toHour = parseInt(toHour) + 12
}

toDate.setHours(toHour)
toDate.setMinutes(toMin)
if (toTime == "12:00 AM&quot

{
toDate.setHours(23)
toDate.setMinutes(59)
toDate.setSeconds(59)
toDate.setMilliseconds(999)
}

diff = toDate.getTime() - fromDate.getTime()

if (diff < 0) {
{alert("Shift cannot span Midnight&quot

; return false;};
}

else if (diff > (1000 * 60 * 60 *12)){
{alert("This block of time is longer than twelve hours! Choosing OK will allow you to continue.&quot

; return true;};
}

return true;

};

mwolf00 · Feb 14, 2003

Yep! I forgot something kinda important... I mishandled 12PM...

<script>
fromTime = "12:00 PM"
toTime = "12:00 AM"

fromDate = new Date()
toDate = new Date()

fromHour = fromTime.substr(0,2)
fromMin = fromTime.substr(3,2)
fromAM = fromTime.substr(6,2)

if (fromAM == "PM" && parseInt(fromHour) < 12){
fromHour = parseInt(fromHour) + 12
}

fromDate.setHours(fromHour)
fromDate.setMinutes(fromMin)

toHour = toTime.substr(0,2)
toMin = toTime.substr(3,2)
toAM = toTime.substr(6,2)

if (toAM == "PM" && parseInt(toHour) < 12){
toHour = parseInt(toHour) + 12
}

toDate.setHours(toHour)
toDate.setMinutes(toMin)
if (toTime == "12:00 AM&quot

{
toDate.setHours(23)
toDate.setMinutes(59)
toDate.setSeconds(59)
toDate.setMilliseconds(999)
}

diff = toDate.getTime() - fromDate.getTime()
alert (fromDate + "\n" + toDate + "\n" + diff)
if (diff < 0) {
alert("Shift cannot span Midnight&quot

}
else if (diff > (1000 * 60 * 60 *12)){
alert("This block of time is longer than twelve hours! Choosing OK will allow you to continue.&quot

}
else{
alert ("ok&quot

}
</script> Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

curt62 · Feb 14, 2003

Tried it...it returns a box that shows the date and time first, click ok and and then another alert OK. Problem is it appears to OK everything now. good and bad entries alike.:-(

mwolf00 · Feb 14, 2003

Copy and paste this onto a blank page and see what you get...

<script>
fromTime = new Array("11:59 PM", "01:15 AM", "03:55 PM","09:00 AM","10:00AM&quot

toTime = new Array("03:00 AM","03:15 PM","12:00 AM", "05:00 PM","10:01 PM&quot

fromDate = new Date()
toDate = new Date()

for (x=0; x<fromTime.length; x++){
fromHour = fromTime[x].substr(0,2)
fromMin = fromTime[x].substr(3,2)
fromAM = fromTime[x].substr(6,2)

if (fromAM == "PM" && parseInt(fromHour) <12){
fromHour = parseInt(fromHour) + 12
}

fromDate.setHours(fromHour)
fromDate.setMinutes(fromMin)

toHour = toTime[x].substr(0,2)
toMin = toTime[x].substr(3,2)
toAM = toTime[x].substr(6,2)

if (toAM == "PM" && parseInt(toHour) <12){
toHour = parseInt(toHour) + 12
}

toDate.setHours(toHour)
toDate.setMinutes(toMin)
if (toTime[x] == "12:00 AM&quot

{
toDate.setHours(23)
toDate.setMinutes(59)
toDate.setSeconds(59)
toDate.setMilliseconds(999)
}

diff = toDate.getTime() - fromDate.getTime()
document.writeln ("From Time: " + fromTime[x] + "   To Time: " + toTime[x] + "   Millisecs:" + diff)
if (diff < 0) {
document.writeln ("Shift cannot span Midnight&quot

}
else if (diff > (1000 * 60 * 60 *12)){
document.writeln ("This block of time is longer than twelve hours! Choosing OK will allow you to continue.&quot

}
else{
document.writeln ("ok&quot

}
document.writeln ("<br>&quot

}
</script> Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

curt62 · Feb 14, 2003

This is what I get....

From Time: 11:59 PM To Time: 03:00 AM Millisecs:-75540000 Shift cannot span Midnight
From Time: 01:15 AM To Time: 03:15 PM Millisecs:50400000 This block of time is longer than twelve hours! Choosing OK will allow you to continue.
From Time: 03:55 PM To Time: 12:00 AM Millisecs:29051055 ok
From Time: 09:00 AM To Time: 05:00 PM Millisecs:28811055 ok
From Time: 10:00AM To Time: 10:01 PM Millisecs:43271055 This block of time is longer than twelve hours! Choosing OK will allow you to continue.

mwolf00 · Feb 14, 2003

Looks right to me - it's not returning "OK" for all of them, only the valid ones....

Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

curt62 · Feb 14, 2003

Duh
I neglected to subsitute

fromTime = document.forms[0].twField0.value
toTime = document.forms[0].twField4.value
for your values
fromTime = "12:00 PM"
toTime = "12:00 AM"

Thanks for your patience..

mwolf00 · Feb 14, 2003

Doh!
Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Time Validation 2

curt62

Programmer

mwolf00

Programmer

jemminger

Programmer

curt62

Programmer

jemminger

Programmer

mwolf00

Programmer

curt62

Programmer

curt62

Programmer

mwolf00

Programmer

curt62

Programmer

mwolf00

Programmer

curt62

Programmer

mwolf00

Programmer

curt62

Programmer

mwolf00

Programmer

curt62

Programmer

mwolf00

Programmer

Similar threads

Part and Inventory Search

Sponsor