Skip to main content
Question

Count the number of Cases by Month

  • September 3, 2018
  • 0 replies
  • 88 views
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?
    This topic has been closed for replies.

    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. 
    • ANSAdmin
    • Author
    • Registered
    • October 10, 2018
    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"




    Terms & ConditionsAccessibility statement