What is the expression to make a specific slice.

[Lozzerr]

I want to create a screen on Appsheet that only displays the Google sheet data rows that are Timestamp = todays date and Action = Clock In. I have tried different expressions, (even going so far as adding new Out and Date columns at the end of the table to see if this would work better - but to no avail) the Action expression works but all dates are shown despite what I have tried. I think the problem is the date. Please could someone tell me what expression should be?

[1minManager · Accepted solution]

AND(
  DATE([Timestamp])=Today(),
  [Action]="Clock In"
)

Simon, 1minManager.com 

[Lozzerr]

Hi Simon, thank you for your assistance, it's working perfectly now. Many thanks!