Question
Calculate how many days between two dates (within repeat region)
What to do to make the function below works within a repeat
region? Each line has a different value for "date1".
function calcDays(){
with(document.form1){
d1=date1.value.split("/");
d2=date2.value.split("/");
d1_dato=new Date(d1[2],d1[1]-1,d1[0]);
d2_dato=new Date(d2[2],d2[1]-1,d2[0]);
days.value=Math.round((d2_dato-d1_dato)/(1000*60*60*24))
}
}
...
<%
While ((Repeat1__numRows <> 0) AND (NOT RSticket.EOF))
%>
<tr>
<td><div align="center">
<input name="date1" type="text" id="date1" value="<%=(RSticket.Fields.Item("vencto").Value)%>" size="8" />
<input name="date2" type="text" id="date2" value="<%= date %>" size="8" />
</div></td>
<td><input name="dias" type="text" id="dias" onfocus="calcData()" size="3" /></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
RSticket.MoveNext()
Wend
%>
function calcDays(){
with(document.form1){
d1=date1.value.split("/");
d2=date2.value.split("/");
d1_dato=new Date(d1[2],d1[1]-1,d1[0]);
d2_dato=new Date(d2[2],d2[1]-1,d2[0]);
days.value=Math.round((d2_dato-d1_dato)/(1000*60*60*24))
}
}
...
<%
While ((Repeat1__numRows <> 0) AND (NOT RSticket.EOF))
%>
<tr>
<td><div align="center">
<input name="date1" type="text" id="date1" value="<%=(RSticket.Fields.Item("vencto").Value)%>" size="8" />
<input name="date2" type="text" id="date2" value="<%= date %>" size="8" />
</div></td>
<td><input name="dias" type="text" id="dias" onfocus="calcData()" size="3" /></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
RSticket.MoveNext()
Wend
%>