Hi,
I’m new to Tap Forms and am trying to figure out what the correct formula would be to calculate the remaining number years and months between “today” and a given “date in the future”.
The “date in the future” is just an existing field in date-time format and which is just completed by using the little drop down calendar…
– What would the correct formula be?
– How will Tap Forms update the “today” element? Will it automatically update that calculated field each time i edit a record? Or how will the result be adapted as time passes by and “today” is changing every day?
– What format should the result be? How will an amount of years and months be represented in the calculated field? Will YY and MM be separated by a comma? How will i be able to read the given result properly without any misinterpretation?
Much appreciated,
Thierry
Hi Thierry,
Sorry for not seeing this post earlier. But I believe we’ve also solved all your questions via email already.
Thanks,
Brendan
.
