Tables: Calculate the number of days between today and submission date

Bom dia,

Por favor como poderia fazer uma formula para calcular quantos dias tenho um atendimento em aberto?

Conforme a imagem abaixo tenho uma data de envio do dia 03/05/24, gostaria de uma formula com a quantidade de dias até o dia de hoje. Seria possivel fazer isso?

Hi Welenson,

Thanks for reaching out to Jotform Support. Our Portuguese Support agents are currently busy helping other Jotform users. 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 Portuguese, let us know and we can have them do that. But, remember that you'd have to wait until they're available again.

I cloned your form and checked the submission data for setting up formulas in the table. I'm a bit confused about what you are trying to calculate, can you explain more about it so I can better understand what's happening? It would be best if you can give us an example.

Once we have a better idea of what’s going on, we’ll be able to come up with a solution.

Boa tarde, tenho o campo "Data de envio" que é a data do preenchimento do formulario!

Na tabela, a opção "adicionar nova coluna", "Formula avancada", gostaria de criar uma formula para pegar a "Data de envio" e usar a data de hoje para calcular (Data de envio (-) Data de hoje) e saber a quantos dias tenho esse chamado em aberto!!!

Da uma olhada na coluna "Dias em aberto", deixei um demonstrativo da minha ideia!!!

Caso precise de mais informações me avise!

Obrigado!

Hi Welenson,

Thanks for getting back to us and clarifying your requirements. Currently, we can't Calculate the number of days between today and the submission date on your submission table. But you can do the calculation using Excel. You need to download the submission data 1st in Excel. Let me show you how:

• Log in to your account, go to All Forms then select the form and click on Submissions.

• Under Tables, click Download All at the upper right part of the page then select Download as Excel.

Once downloaded, open the file and follow this guide.

Reach out again if you have any other questions.