I am having trouble figuring out how I can make a date by adding a number of days to a given date. i have a form that has several number fields, and i need to take those numbers from the db and make dates by adding the number of days to the base date of the contract to generate those dates.

Any one have an idea on how to acomplish this?

Hi rjp, have you looked through : Tutorials - Adalo Resources As for basic Calculation, one can use : “red T” button -(end of line “Text”) then play with Formula Adding values to fields, hope it helps …as for date, I could not get other results than "xx days ago - instead of a more needed " …

Thanks, i have worked with the magic text and formulas, but cant get and date fields to work. Im curently working with airtable to make it work, but hate to have to do so much work for a simple calculation.

…but cant get and date fields to work. mine works fine, ie today’sdate+30 gives the right results… What is the formula you are trying to calculate like ? :upside_down_face:

I need to pull a date from my db and a number from my db and add the two together. example 10/12/2020 + 14 and get 10/26/2020. but cant a get a long decimal number as the result. if i use the values in the date field to add to a curent date it works fine, but not with two db values.

Can you show what is the result when you use a db value ? nothing or a number …?

i get a long integer like 14.23485800556

can you change your adding value to 16 for instance … To see if “14”.*** is related to your 14 days delay ? You should get 16.**** if so …

Finally, could you get the right formula to your project ?

Create a date by adding a number of days from a given day

Get Help

karimoo July 7, 2020, 6:22am 11

Have a look @ Help : StarTIME +60 = funny Endtime 🤔 - #3 by karimoo or
How to calculate with days and minutes

Topic		Replies	Views
Display custom formula as a date Get Help	6	786	July 29, 2021
Error with formulas with dates involved Get Help	8	90	September 28, 2024
Date calculations Get Help	2	1292	October 6, 2022
Date + Number - Why does this not work in Adalo Get Help	6	1133	January 22, 2022
Calculate date and update database property Get Help	3	60	September 9, 2025

Create a date by adding a number of days from a given day

Related topics