2. PHPRunner General questions
  3. [SOLVED]  Calculate Date Field On The Fly
This topic is locked
[SOLVED]

 Calculate Date Field On The Fly

 		7/7/2013 4:48:13 PM
PHPRunner General questions
O
 onlline author

I have a table which has 2 DATE fields (taxa_date, taxa_expira).

On the "add record" form i would like to have the second date field(taxa_expira) to be calculated on the fly, after the first field its inserted (taxa_date).
I've tried the following code in the "Javascript onload event", but its not working. (I'm using Simple edit box with datepicker)
var ctrlData = Runner.getControl(pageid, 'taxa_date');
var ctrlExpiry = Runner.getControl(pageid, 'taxa_expira');
function func() {
if ( ctrlData.getDate()!='' && !isNaN(ctrlData.getDate()))
ctrlExpira.setDate(ctrlData.getDate()+365);
else
ctrlExpira.setDate('');
};
ctrlData.on('keyup', func);
C
 		cgphp 7/8/2013
var ctrlData = Runner.getControl(pageid, 'taxa_date');

var ctrlExpira = Runner.getControl(pageid, 'taxa_expira');
function checkDate(d)

{

var timestamp = Date.parse(d);

if(!isNaN(timestamp) && timestamp > 0)

{

return timestamp;

}

return false;

}
function func()

{

var d = ctrlData.getValue();

var timestamp = checkDate(d);

if(timestamp !== false)

{

var endDate = new Date(timestamp + (24 * 60 * 60 * 365 * 1000));

ctrlExpira.setValue(endDate);

}

else

{

ctrlExpira.setValue('');

}

}
ctrlData.on('keyup', func);
O
 		onlline author 7/8/2013


var ctrlData = Runner.getControl(pageid, 'taxa_date');

var ctrlExpira = Runner.getControl(pageid, 'taxa_expira');
function checkDate(d)

{

var timestamp = Date.parse(d);

if(!isNaN(timestamp) && timestamp > 0)

{

return timestamp;

}

return false;

}
function func()

{

var d = ctrlData.getValue();

var timestamp = checkDate(d);

if(timestamp !== false)

{

var endDate = new Date(timestamp + (24 * 60 * 60 * 365 * 1000));

ctrlExpira.setValue(endDate);

}

else

{

ctrlExpira.setValue('');

}

}
ctrlData.on('keyup', func);



Christian, Thanks
is possible using datepicker?
Thanks in advanced
C
 		cgphp 7/8/2013

My code should work also for "Simple edit box with datepicker".