how to compare 2 cell values in a row which is greater.

Suite and Optimus Suite 5
#1
#2

This is more of a generic javascript question than DHTMLX but here is a function that might do the trick (credit to www.daniweb.com) -

function validate(dt1,dt2)
{
var jdt1=Date.parse('01 Jan 2000 '+dt1);
var jdt2=Date.parse('01 Jan 2000 '+dt2);
if (jdt1>jdt2)
{
alert(‘start is greater’);
}
else
{
alert(‘start is less equal’);
}
}

#3

in javascript i have done it like

	 var fromtime=document.myform.f_time.value;
	 var totime=document.myform.t_time.value;
	 var ft=fromtime.split(":");
	 var tt=totime.split(":");
	 var ok=false;
	 if(tt[0]*1 > ft[0]*1) {ok=true}
	 if((tt[0]*1 == ft[0]*1) && (tt[1]*1 > ft[1]*1)){ok=true}
	 if(ok)
		{
		 alert("condition is true");
		  var hr=tt[0]-ft[0];
		  var mn=tt[1]-ft[1];
		  if(mn<0){mn=mn+60; hr=hr-1}
		  if(mn<10){mn="0"+mn}
		  //alert("total hours:"+hr+":"+mn);
		}
	 else
		{
		  alert("TO_TIME should be greater than FROM_TIME.");
		}

i need this using dataprocessor validation
function validate_grid(value,id,ind)
{
//here checking comparision for ind==1 and ind==2
}

where ind==1 is start time and ind==2 is end time,time is 2hrs format.

Regards
narinas.

#4

i think this not possible with dataprocessor.