Select Statement help cannot compare date with list

[Brandon_Ekbatan]

Can someone please help me fix this statement? I am trying to get a working select statement, to select all the tasks related to a project where (in the task table) the last update is wihtin 24 hours of now.

Here is the select statement:

that I will eventually turn to template expressions here:

[Marc_Dillon]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

[Brandon_Ekbatan]

I see this is a valid solution from your guide:

but it still doesnt work in the “Template Expression”

[Brandon_Ekbatan]

report does not send with this

[Marc_Dillon]

Is [Project Name] the key column of the ITPM_Tasks Table?

[Brandon_Ekbatan]

simpple uml table i made:

[Marc_Dillon]

help.appsheet.com

Template Start Expressions

Using Start expressions in your workflow templates.