¿Cómo puedo restar entre 2 columnas diferentes que contienen fechas actuales y registradas?

Hola, quisiera saber como puedo realizar una resta entre una columna que mantenga la fecha hoy (actual) menos la fecha registrada en otra columna.

Es posible realizar esta operación?

Quedo atento a sus gentiles comentarios.

Hi Jorge,

Thanks for reaching out to Jotform Support. Our Spanish Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, you can subtract the current date from the recorded date by adding the Form Calculation Widget to calculate the result. Let me show you how:

1. In Form Builder, click +Add Form Elements on the upper left side
2. Under the Basic tab, select the Date Picker Element for the Current and Recorded fields.
3. Drag and Drop it into your form and Rename it.
4. Go back to the Form Element and go to the Widget.
5. Find the Form Calculation Widget and Drag it at the bottom of the form.

Here's the screenshot of the calculation in the Form Calculation Widget.

Check out the screencast of the result below:

If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Give it a try and let us know how it goes.

Agradezco tu oportuna respuesta, pero las solución solo cubre parte de mi problema. Lo que busco es que en la Tabla, la columna HOY pueda actualizar automáticamente la fecha a medida que pasan los días, para que el resultado de la resta de (fecha de vencimiento - HOY) cambie a medida que pasen los dias.

Espero haber sido claro para que puedan orientarme

Saludos

Jorge

Hi Jorge,

Unfortunately, it is not possible to set the date column in the Jotform Table to automatically update the Today Column when setting up the subtractions. You can try the above suggestion and check out this guide for more information.

Let us know if you have any other questions.