Add a variable number of days to a Datetime field

AppSheet AppSheet Q&A
1

Hello everyone,

I have a column “NewDataInizio” with a datetime type and a column “DurataRep” with the amount of days to add to the value in “NewDataInizio”

dennis35_0-1702988496579.png
dennis35_0-1702988496579.png250×343 8.92 KB

To calculate the final date “NewDataFine” I used this expression:

[NewDataInizio]+ (TIME(([DurataRep]*24)&“:00:00”)-“00:00:00”) but the result is not the one expected

(it adds about 70 years).

dennis35_1-1702988704868.png
dennis35_1-1702988704868.png283×364 9.9 KB

How could I obtain the right result ?

For example, if I have “NewDataInizio” valued with 3/21/2024 8:00:00 AM

and the value in “DurataRep” is 7 days

the value for “NewDataFine” should be 3/28/2024 8:00:00 AM

Thanks

2

[NewDataInizio] + [DurataRep] should be just fine.