
Corrie Watson asked a question.

Corrie Watson asked a question.

Hello,
Yes, you can achieve this with a calculation! Here's a possible solution:
COUNT(Clients.CreatedDate) WHERE MONTH(Clients.CreatedDate) = MONTH(TODAY())
This formula counts the number of new clients created in the current month.
Consult your app's documentation or support team for specific implementation guidance.

Thanks @Michael Gardner . I tried this using COUNT(@All of Date of First Contact) WHERE MONTH(@All of Date of First Contact) = MONTH(TODAY()) - Date of First Contact is the field that records when the client contacted us, but I'm getting an error - Script syntax error: unexpected identifier. Not sure what I'm doing wrong! Any help gratefully received!

@Michael Gardner Any chance you could help me with this? I'm really struggling to get this formula to work! Many thanks..
Hello,
Yes, you can achieve this with a calculation! Here's a possible solution:
COUNT(Clients.CreatedDate) WHERE MONTH(Clients.CreatedDate) = MONTH(TODAY())
This formula counts the number of new clients created in the current month.
Consult your app's documentation or support team for specific implementation guidance.