you can use the Date and Date# function.
First use Date# which reads a string and interpets as a date:
Date#( [FieldName],'YYYY-MM') as NewDate
Then you can change the date format display using Date() . Wrap it around the Date# so the result of Date# flows right into the Date function as follows:
Date( Date#( [FieldName],'YYYY-MM') , 'MM/DD/YYYY' ) as NewDate
Basically you need a string that contains all the three information required for a date ie Year , Month and Day otherwise,by using the following conversion ,
Date(Date#([Your Date Field],'YYYY-MM') , 'MM/DD/YYYY') is always going to use 1 as the day for your dates
2015-01 will be 01/01/2015
2015-02 will be 02/01/2015
Thank you all for your help!
I have one more question about the date format.
My chart has month/year on the axis but it only shows the months that have corresponding amount. Is it possible to format so that it shows other months that do not have any data? Or would I have to create months on the spreadsheet manually?