ZOHO CRM - Date format Question
In the CRM module there is a field called 'Closing Date' in the Potential file. I need to create a variable that pulls out the month and year. Closing date = 11/08/2013 I want a variable = 112013.
I'm trying to run reports that sub-total on MonthYear regardless of the actual closing date within that month.
I created a variable using this function Month(${Potentials.Closing Date})
This does get me the month but I don't know how to concatenate the year.
Thank you for your help!