date difference

Hello @civilvicky

Yes, of course. The code in this case would be:

(function(){
var o = DATEDIFF(NOW(), fieldname1, 'dd-mm-yyyy', 'y');
return o['years']+' year '+o['months']+' months '+o['days']+' days';
})();

Best regards.

Hello @civilvicky

No, I’m sorry, you are confused. The difference between 05/28/1995 and today is 27 year(s) 10 month(s) 8 day(s)

I’ve calculated it with Excel:

There is a difference of one day because our plugin takes into account the first and the last day.

About your second question, you can use the DATETIMESUM operation to increase the date object and the GETDATETIMESTRING operation to get the date object as text in a specific format:

GETDATETIMESTRING(DATETIMESUM('01/04/2023', 'mm/dd/yyyy', 1, 'y'), 'mm/dd/yyyy')

Learn more about the date/time operations module by reading the following section in the plugin documentation:

https://cff.dwbooster.com/documentation#datetime-module

Best regards.

Hello @civilvicky

The DATETIMESUM operation returns a Date object. The alternatives would be call the WEEKDAYNAME, MONTHNAME, and YEAR operations using the DATETIMESUM. For example:

(function(){
var d = DATETIMESUM(fieldname1, 'yyyy-mm-dd', 7, 'd');
return WEEKDAYNAME(d)+' '+MONTHNAME(d)+' '+DAY(d)+' '+YEAR(d);
})()

Best regards.