Sumif total from date and time for todays date

AppSheet AppSheet Q&A
1

I have tried with this expression SUM(SELECT(Order Details[Total],[User Order]=USEREMAIL(),[Date and Time]=TODAY())).
Here, this expression is resulting in entire column total. Column [Date and Time] has day, Date and time, which is failing to look for todays date.

2

Also:

Note, too, that TODAY() produces a Date value. When compared to a DateTime value, as [Date and Time] presumably is, the Date value will be converted to a DateTime value with a time component of 00:00:00 (i.e., midnight), which probably isn’t what you want. To compare the dates without regard to times, change this:

[Date and Time]=TODAY()

to this:

DATE([Date and Time])=TODAY()
1 Like
3

Thank you, Mark and Steve.
Its working. I have changed it to
SUM(SELECT(Order Details[Total],and([User Order]=USEREMAIL(),date([Date and Time])=TODAY())))

1 Like