# Discussions

View Only

## Count the number of Cases by Month

• #### 1.  Count the number of Cases by Month

Posted 09-03-2018 13:09
So I'm creating a custom reference with "SY-MM-YYYY-CASE-GENDER"
This my current formula:
"SY"
& "-"
& Month(ToDate([Date Created]))
& "-"
& Year(ToDate([Date Created]))
& "-"
Count(ToDate([Date Created])) <-- Current Problem
& "-"
& [Gender]

How to count the number of records by month using formula-text?

• #### 2.  RE: Count the number of Cases by Month

Top
Contributor
Posted 09-03-2018 20:34
I think that you will need to take a step back and explain your use case.  If you want to count the number of Cases per month, you can just make a Summary report.

You may have a use case which does require the Values to be on records, and if you can explain that, there is likely a solution.

• #### 3.  RE: Count the number of Cases by Month

Posted 10-10-2018 13:05
Example, I created 3 records this month so the formula-text i made will show "PE-01-2018" "PE-02-2018" "PE-03-2018" then if it's the new month the first record i create will be "PE-01-2018"