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!
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
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
3 |