Dropdown Value as Date for Calculation

Hi,

The plugin does not recognize dynamically texts with date format. You must use in this case a “Date” field, and preserves the current equation.

If you want to use another type of field (and not a date field), with a text in date format (in whose case you should represent the year with four characters), you will need the developer version of the plugin, and then use the date/time module (more information in the following link:
https://cff.dwbooster.com/documentation#datetime-module). For example, using the equation:

GETDATETIMESTRING(DATETIMESUM(fieldname74, 'dd/mm/yyyy', fieldname75), 'dd/mm/yyyy')

Best regards.

Thanks for the feedback!
I have purchased the developer plugin. Can I just overwrite the current one in the plugins folder without losing the form I have already created?
Regards,
Chris

Hi @chris,

Please, do not replace the plugin’s files, follow the instruction in the following link that preserves the forms created previously:

https://cff.dwbooster.com/documentation#installation

Best regards.

OK have it working.

A further question in relation to Date Calculation!

In a calculated field I want to mirror the value of (fieldname74 – 1 day)

I am using this:
GETDATETIMESTRING(DATETIMESUM(fieldname74, ‘dd/mm/yyyy’, -1, ‘d’))

But getting this output
2016-09-04 12:00:00 am
instead of:
19/09/2016

Also how can I minus a day from the calculated field of the equation above?

I am trying this:
GETDATETIMESTRING(DATETIMESUM(fieldname76, ‘dd/mm/yyyy’, -1, ‘d’))

Where fieldname76 is the result of the calculated field above.

Thanks again,
Chris

Hi,

In the case of first equation, you should define the format of the output:

GETDATETIMESTRING(DATETIMESUM(fieldname74, 'dd/mm/yyyy', -1, 'd'), 'dd/mm/yyyy')

Furthermore, as the operation by default is the sum of days, the operation can be simplified as:

GETDATETIMESTRING(DATETIMESUM(fieldname74, 'dd/mm/yyyy', -1), 'dd/mm/yyyy')

The case of second equation is more complex, because the plugin always converts the calculated fields to its numeric representation, to be used in mathematic operations, in this case please, follow the steps below:

1. Select the fieldname76 in the form, and assign to it a custom class name, that should be unique in the form, for example: f76

Note: The class names are assigned through the attribute: “Add Css Layout Keywords”

2. Now, edit your second equation as follows:

(function(){
var tmp = fieldname76;
var v = jQuery('.f76 input').val();
return GETDATETIMESTRING(DATETIMESUM(v, 'dd/mm/yyyy', -1),'dd/mm/yyyy');
})()

Note: The line of code var tmp = fieldname76; is not used in the equation, but it is included to let you know to the plugin that the fieldname76 field is used in the equation, and it should be evaluated each time the value of the fieldname76 varies.

Best regards.

Thanks for the amazing support!
Will try it out and get back to you.
Regards
Chris