Date

[Martin_Jeffreys]

I am trying to receive a result of how many people were born in eg Oct in search filter. i have a slice wich includes Birth date eg: 15 Oct 1957 & I only want to get results for Oct or any other month entered into search . Please help

[TeeSee1]

Not sure what your intended UX looks like but the expression MONTH([date]), which gives you the month of the date, should be able to give you the information required in combination of COUNT(FILTER("table", MONTH([birthday)] = the month of search field)).

[Martin_Jeffreys]

Hi Teesee

I could not get your code to work unfortuneatley. I have screen copied my Ux so you can see for yourself.

I am receiving the following error  

Expression 'COUNT(FILTER("Jeff", MONTH([birth Date)] = the month of search field)).' was unable to be parsed: Number of opened and closed parentheses does not match.

[AaronTerry]

Try this but modify the table and columns to match your app:

COUNT(SELECT(People[Name], CONTAINS([Birth date], [Search])))

https://help.appsheet.com/en/articles/2357314-select
https://help.appsheet.com/en/articles/2347639-contains

[Martin_Jeffreys]

Hi Aaron

I cannot get your code to work unfortuneatley. I have modified to my tables & columns

COUNT(SELECT(Jeff[Surname], CONTAINS([Birth date], [Search])))

I am receiving following error.

Unable to find column 'Search', did you mean 'Gender'?.

Please Help

[AaronTerry · Accepted solution]

I used the word Search to give you an idea of how these work in reference to yours. The system is saying you do not have a column called Search. Replace it with the column you're entering the birth month into.