Support » Plugin: Calculated Fields Form » Date Calculator

  • Resolved adisaputro25

    (@adisaputro25)


    Thanks for create this plugin,

    I want to count:

    date (not current date) + months = new date

    like this:

    23/05/2017 + 4 months = ____

    How to count this with your plugin? what the formula?

    Thank You

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello,

    There is an easy and a hard way to implement this behavior. The easy way is using the Date/Time module distributed with the Developer and Platinum versions of the plugin, the hard way is using directly the Date object of javascript.

    For example, assuming that the date/time field is the fieldname1.

    The easy way:

    GETDATETIMESTRING(DATETIMESUM(fieldname1, 'mm/dd/yyyy', 4, 'm'), 'mm/dd/yyyy')

    The hard way:

    (function(){
    var d = new Date(fieldname1*86400000);
    d.setMonths(d.getMonths()+4);
    return CDATE(d/86400000,'mm/dd/yyyy');
    })()

    The support service does not cover the implementation of the users’ projects (forms or formulas), but if you need additional help implementing your project, I can offer you a custom coding service from my private website:

    https://cff.dwbooster.com/customization

    Best regards.

    Thread Starter adisaputro25

    (@adisaputro25)

    Thank you for fast respond, i will using easy way and looking for platinum version

    Thanks again.

    Plugin Author codepeople

    (@codepeople)

    Hello,

    Please, remember the easy way is only possible if you have installed the Developer or Platinum versions of the plugin, because the Free and Professional versions do not include the Date/Time operations module.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Date Calculator’ is closed to new replies.