Dear @Steve , thank you very much for your answer.
I know the use of the above formula.
When I first needed to calculate the number of days between two dates, I learned this use on the form and by reading your articles. The form contains examples of this use. I know that.
But this is a bit of a forced method.
When Google Spreadsheets Excel came out as a competitor, it introduced many functions of Excel as they were.
So people switched from Excel to Google Spreadsheets without learning anything new.
Many things that are known to be done in Excel and SQL can also be done to AppSheet.
For example, the function between two dates is generally used as follows.
Sql: DATEDIFF (DAY, ‘19900101’, ‘20201229’)
Delphi: DaysBetween (D1, D2)
Excel 2013 and later: Days (D1, D2) or DATEDIF (Start_date, End_date, “D”)
PHP: date_diff ( datetime1, datetime2);
Python: Variable = d1 - d2
Google Spreadsheet: Minus (D1-D2) or DATEDIF (d1, d2, ”D”)
or other programming languages, using similar functions.
I only see Powers app as a competitor to Appsheet. Others are just babies.
Appsheet, If Microsoft is going to be a competitor, it should definitely standardize its functions. So let’s use these functions based on our previous knowledge and feelings. Let’s not do research. Let’s not learn a new method.