Filter Date and Time

[aquintas]

Hello Together

I am a newbie on appsheet progammierenung, so hope that I can find a simple solution for a filter.

Columns.
1 [Geplantes Datum] -> Date
2. [Geplante Zeit] -> Time

Filter:
It should show result only if Date=today and time is 09:00.

[Geplante Zeit] = "09:00"
[Geplantes Datum] = "today(0)"

This does not work like this, what am I doing wrong?

[Marc_Dillon]

https://help.appsheet.com/en/articles/2347624-and

https://help.appsheet.com/en/articles/961346-date-and-time-expressions

[Steve]

https://help.appsheet.com/en/articles/2357327-today

https://help.appsheet.com/en/articles/2347624-and

[aquintas]

Many thanks for the informative links
unfortunately I do not get this.

both filters work separately but if you do both filters together, nothing comes.

Can you help me with this?

([Geplantes Datum])=today(),[Geplante Zeit] = 09:00

[Steve]

Read the help doc for AND().

[Josh_Klassen]

https://help.appsheet.com/en/articles/2347624-and

Maybe try this: