interactive chart data in yyyy-mm-dd but chart x-axis showing Mmm-yyyy

[JLiou]

Hi,

I have date field in format yyyy-mm-dd going into a line interactive-chart and I want to keep it in that format in the x-axis, however the output chart keep displaying it as Mmm-yyyy.  How do I configure the chart to display the date x-axis as my original yyyy-mm-dd format?

thanks

John

[Qiu]

@JLiou 
It seems that we can use the DateTime tool to forcely convert the Date format to a String, while the using the Select tool will not work.
It is really weired though.

[JLiou]

My fear came true, the ordering of the week using the converted to string field is a mess in the chart even though I've sorted it using the date field before it went into the chart but the output chart is a mess. 

[JLiou]

Strange, but when I deleted the interactive chart tool and add it again, it seems to fix the ordering of the date but the format of label went back to Mmm-yyyy even though the format of the field "week_start_str" in the x-axis is in yyyy-mm-dd?