I'm trying to get the a query setup so it delivers the date for each lead in a format of just the month. Right the filter I have is working fine, but the CreatedDate format returns this rediculous format that I can't get to work in third part apps.
Here's the Query:
SELECT CALENDAR_MONTH(CreatedDate),LeadSource FROM Lead WHERE LeadSource AND CreatedDate = THIS_YEAR
It should look in the Lead Object and find the month of the created date and the lead source and filter them by leadsource and this years created dates. Or at least that's what I want. I get an error in the Salesforce Workbence and I have no idea why.
Any help would be great.