I created a derived table that count the leads that we got in each day:
Instead of that, I want to count the number of the leads we got each MONTH. For that I need to cast the dates to a different format (MM-YYYY).
I tried to use the FORMAT function, but the query failed:
Do you have any suggestions? other solutions?