Date field validation

[Dmitry Kozlov]

Hi,

The code from my previous message retrives a date-object based on both date and time. So you can use it to compare two date and time fields:

Code: Select all

function getHours(str) {
	var parts = str.split(' ');
	if (parts[1] == 'PM') {
		return parseInt(parts[0]) + 12
	}
	
	parseInt(parts[0])
}

var dt = fd.field('startDate').value();
var dateParts = dt[0].split('/');
var startDate = new Date(dateParts[2], dateParts[0]-1, dateParts[1], getHours(dt[1]), dt[2]);

dt = fd.field('endDate').value();
dateParts = dt[0].split('/');
var endDate = new Date(dateParts[2], dateParts[0]-1, dateParts[1], getHours(dt[1]), dt[2]);

alert(endDate > startDate);

[davidnarramore]

Thank you so much Dimitry. This worked great! When would be the best time to do this validation? On submit? would that be fd.onsubmit( );

[davidnarramore]

Thank you so much Dimitry. This worked great! When would be the best time to do this validation? On submit? would that be fd.onsubmit( );

[Dmitry Kozlov]

Hi,

Yes, if you need to validate the fields before the submission, just put this code into onsubmit handler:

Code: Select all

function getHours(str) {
	var parts = str.split(' ');
	if (parts[1] == 'PM') {
		return parseInt(parts[0]) + 12
	}
	
	parseInt(parts[0])
}

fd.onsubmit(function() {
	var dt = fd.field('startDate').value();
	var dateParts = dt[0].split('/');
	var startDate = new Date(dateParts[2], dateParts[0]-1, dateParts[1], getHours(dt[1]), dt[2]);

	dt = fd.field('endDate').value();
	dateParts = dt[0].split('/');
	var endDate = new Date(dateParts[2], dateParts[0]-1, dateParts[1], getHours(dt[1]), dt[2]);

	if (endDate < startDate) {
		alert('End Date must be greater than Start Date.');
		return false;
	}
	
	return true;
});

[davidnarramore]

When I put the code in the alert displays as expected. When I change the time so the endDate is greater than the startDate the alert continues to display.

[Dmitry Kozlov]

Please, try to trace variables before the comparison. Also, ensure that you don't have JS-errors in the browser console.

Code: Select all

alert(endDate);
alert(startDate);
if (endDate < startDate) {
	alert('End Date must be greater than Start Date.');
	return false;
}

[SpongeBen SquareJaw]

You need to fix the gethours function for this to work put in ; and retun

function getHours(str) {

var parts = str.split(' ');

if (parts[1] == 'PM') {

return parseInt(parts[0]) + 12;

}

return parseInt(parts[0]);

}

[Dmitry Kozlov]

Exactly! Many thanks.

[SpongeBen SquareJaw]

Actually, I have a correction to my correction. It seems if it is 12 PM and if you add 12 the value would be

24 so it would add a day. This should be solid now. For DateTime Comparison



function getHours(str) {

var parts = str.split(' ');

var partHour = 0;

if (parts[1] == 'PM') {

partHour = parseInt(parts[0])

if (partHour != 12){

return parseInt(parts[0]) + 12;

}

}

return parseInt(parts[0]);



}

[Katy]

I am checking if the date and time field is empty, but can't make it work, here is what i have after reading the above:

function getHours(str) {


var parts = str.split(' ');


if (parts[1] == 'PM') {


return parseInt(parts[0]) + 12;


}


return parseInt(parts[0]);


}




fd.onsubmit (function () {


var dt = fd.field('DueDate').value()

if (Boolean(dt[0])) {


var dateParts = dt[0].split('/');


var date = new Date(dateParts[2], dateParts[0]-1, dateParts[1], getHours(dt[1]), dt[2]);


alert('Fill out date');


}

return false;


}



return true;


});