Difference between dates

[amorap]

Please if you can help me. I need to write a formula for appsheet that subtracts between the "End Date" column and the "Start Date" column and returns the value in number. I need that formula to place it in a virtual column. The columns "End Date" and "Initial Date" are in the sheet named "Sumacolumnas". Calculated the virtual column with the number of days I need to be able to load it to the database to the "Difference" column.

Thank you very much. Grateful for the help. I am learning appsheet.

Alberto

[dbaum]

From Date and time expressions - AppSheet Help:

• [EndDate] - [StartDate] : the Duration between StartDate (a Date) at midnight and EndDate (a Date) at midnight.

[dbaum]

@amorap wrote:

I need to be able to load it to the database to the "Difference" column

---

Pues, no use una column virtual. Cree una columna en la misma base de datos y en AppSheet utilice la misma App formula como si fuera columna virtual.