Count the number of Cases by Month
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...
Forum Discussion
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"