"min" and "max" time-values as a daily sumary

AppSheet AppSheet Q&A
1

In my database i am collecting many tasks every day - each task with column1 = “StartTime” and column2 = “EndTime”.

At the end of each day i manualy insert a row as a summary - in this row i have one “Date-column” (> initial value = Now()) and 2 additionow colums for automatic calculation

a) Min(Start-Time) and

b) ax(End-Time) for all the entries (tasks) of this specific day.

Calculation of “Min” an “Max” values is no problem (Min(List([CStartTime])) // Max(List([CEndTime])) > works fine!

How do i have to set up expression for only selecting entries (tasks) of the “actual day” (= “Date-Column” of “summary” row) ?

many thanks in advance for your help!

2

You almost anwered your own question when you wrote “expression for only selecting” – I think you need to use the SELECT() expression:

https://help.appsheet.com/en/articles/2357314-select

1 Like