Number and Date Relationship

Hello @pexel

Thank you very much for using our plugin.

If the feldname1 is a date field, and the number fields fieldname19 has a year value, fieldname20 months, fieldname21 weeks, and fieldname22 days, and you want to sum them to the date field and get the result in date format. You can insert a calculated field in the form and enter the following equation:

(function(){
var result = fieldname1;

result = DATETIMESUM(result, 'dd/mm/yyyy', fieldname19, 'y');
result = DATETIMESUM(result, 'dd/mm/yyyy', fieldname20, 'm');
result = DATETIMESUM(result, 'dd/mm/yyyy', fieldname21*7+fieldname22, 'd');

return GETDATETIMESTRING(result, 'dd/mm/yyyy');
})()

Best regards.

What if we want to extract it the same way?
You’re great at support, by the way.

Hello @pexel

If you want to extract date components and assign them the number fields, the equation in the calculated field would be:

(function(){
getField(fieldname19|n).setVal(YEAR(fieldname1));
getField(fieldname20|n).setVal(MONTH(fieldname1));
getField(fieldname21|n).setVal(WEEKNUM(fieldname1));
getField(fieldname22|n).setVal(DAY(fieldname1));
})()

Note the use of |n modifier in fieldname19|n, fieldname20|n, fieldname21|n, and fieldname22|n. The plugin replaces the fields’ names with their values before evaluating the equations. The |n modifier tells the plugin you are referring to the fields’ names directly instead of their values.

Best regards.

then I’m writing to wrap it up, if there is a wrong part, I would appreciate it if you could help.
When adding a date function;

(function(){
var sonucsure = fieldname17;

sonucsure = DATETIMESUM(sonucsure, 'dd/mm/yyyy', fieldname19, 'y');
sonucsure = DATETIMESUM(sonucsure, 'dd/mm/yyyy', fieldname20, 'm');
sonucsure = DATETIMESUM(sonucsure, 'dd/mm/yyyy', fieldname21*7+fieldname22, 'd');
jQuery('#calculation-sonucsure').html(sonucsure);
return GETDATETIMESTRING(sonucsure, 'dd/mm/yyyy');
})()

I couldn’t print the result “calculation-sonucsure”

In fact, I’m currently thinking about how to do the subtraction as above and vice versa. I failed ??

Hello @pexel

In the line of code:

jQuery('#calculation-sonucsure').html(sonucsure);

sonucsure is an object, the GETDATETIMESTRING operation transform it into a text with date format. So, the option would be transform it before displaying it on the page and return the equation:

(function(){
var sonucsure = fieldname17;

sonucsure = DATETIMESUM(sonucsure, 'dd/mm/yyyy', fieldname19, 'y');
sonucsure = DATETIMESUM(sonucsure, 'dd/mm/yyyy', fieldname20, 'm');
sonucsure = DATETIMESUM(sonucsure, 'dd/mm/yyyy', fieldname21*7+fieldname22, 'd');

sonucsure = GETDATETIMESTRING(sonucsure, 'dd/mm/yyyy');
jQuery('#calculation-sonucsure').html(sonucsure);
return sonucsure;
})()

For additional questions, please, indicate the URL to the page that contains the form to check your equation in action.

Best regards.

Thanks, I realized my mistake and got the result.
A very impressive plugin.