Support » Plugin: Calculated Fields Form » Date Calculator

  • Resolved 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



    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:

    var d = new Date(fieldname1*86400000);
    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:

    Best regards.

    Thread Starter adisaputro25


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

    Thanks again.

    Plugin Author codepeople



    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.