Conditional Count of Members Referred this Month

Hi All! 

Hoping to find some help with a calculated field I'm trying to create. In our CRM we have a module ("Partners") that refer us our Members. I am wanting to set up a calculated field that counts the # of members were created in the current month. Using the following formula the field saved without error, but after recalculating values the value was incorrectly 0 seen from the list view. I then tried to open the record and it gave me this error: 

HTTP: 500 Internal Server Error

attempt to convert invalid value to date: undefined

Here is the formula I am currently using: 

countConditional($hsd_partners_hsd_members,"numeric_month_referred_c",monthofyear(today()))

The "Numeric Month Referred" field take the "Date Created" Field and converts it to a numeric Month (Jan=1,Feb=2...)

Any Ideas? 

Parents Reply Children
No Data