Math with dates?

I also have this question. ??

I need to subtract 2 dates to find the number of months. how do I do that?

You’ll need to update the caldera-forms/fields/calculation/field.php file.

Change this line (~62)

$binds_vars[] = $fid . " = parseFloat( $('[data-field=\"" . $fid . "\"]').is(':checkbox') ? checked_total_" . $field_base_id . "($('[data-field=\"" . $fid . "\"]:checked')) : $('[data-field=\"" . $fid . "\"]').is(':radio') ? $('[data-field=\"" . $fid . "\"]:checked').val() : $('[data-field=\"" . $fid . "\"]').val() ) || 0 ";

With this :

if($cfg['type'] == 'date_picker') {
	$binds_vars[] = $fid." = ((new Date( $('[data-field=\"".$fid."\"]').val() )) / (1000 * 3600 * 24))";
} else {
	$binds_vars[] = $fid . " = parseFloat( $('[data-field=\"" . $fid . "\"]').is(':checkbox') ? checked_total_" . $field_base_id . "($('[data-field=\"" . $fid . "\"]:checked')) : $('[data-field=\"" . $fid . "\"]').is(':radio') ? $('[data-field=\"" . $fid . "\"]:checked').val() : $('[data-field=\"" . $fid . "\"]').val() ) || 0 ";
}

This will convert your date to a number of days. So when you substract dates, you’ll get number of days between them.

You also have to change the Caldera_Forms::run_calculation() function in caldera-forms/classes/core.php (~1017)

Search for this : (~1049)

if (is_array($entry_value)) {
	$number = floatval(array_sum($entry_value));
} else {
	$number = floatval($entry_value);
}

To change it for :

if($cfg['type'] == 'date_picker') {
	$number = empty($entry_value) ? 0 : (strtotime($entry_value) / (3600 * 24));
} else {
	if (is_array($entry_value)) {
		$number = floatval(array_sum($entry_value));
	} else {
		$number = floatval($entry_value);
	}
}

Forked it in with the fix my Github :
https://github.com/pboissonneault/Caldera-Forms

I tried the above changes, however it did not work and it broke all calculation. Do you perhaps have a solution for the latest version of the plugin (Version 1.4.3.1)