Count between two dates

[apocunningham]

I could use some of the communities expertise. I'm trying to count between two dates and am at a loss. My TimestampEntered column has an initial value of NOW(). When i've used a simliar expression in the past including Today(), for example, <<Count(Select(Court[ID],And(Date([TimestampEntered])=Today(),[CountyID]="Illinois – Alexander County")))>> the expression has worked great, but now I need to use specific date for research. Any assistance you can provide with my below expression, would be much appreciated!

<<Count(Select(Court[ID], And(Date([TimestampEntered])>=9/1/2022, And(Date([TimestampEntered])<=9/7/2022, [CountyID]="Illinois – Alexander County"))))>>

Thank you so much!!

[Marc_Dillon · Accepted solution]

You need to put your dates in quotes.

[Steve]

Date and time expressions - AppSheet Help