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?