You can change the format of most date/time fields from data sources by using the advanced setting "TIME_DIMENSION_FORMAT_???" -where the ??? is the chosen format, for example: "TIME_DIMENSION_FORMAT_Ym". The string for this is placed under the Options->Advanced settings section of the sidebar, as shown below:
Some common formatting examples:
| Special setting | Basic format | Example output |
|---|---|---|
| TIME_DIMENSION_FORMAT_m/d/Y | mm/dd/YYYY | 01/02/2018 |
| TIME_DIMENSION_FORMAT_m-y | mm-yy | 01-18 |
| TIME_DIMENSION_FORMAT_H:i:s | HH:ii:ss | 14:23:04 |
| TIME_DIMENSION_FORMAT_F Y | month YYYY | January 2018 |
For a full list of formatting options, see: https://secure.php.net/manual/en/datetime.createfromformat.php
If you want to use comma between the different date values, you need to write it as in "comma".
WARNING: Please note that optional setting "Format results for Google Data Studio" overrides the custom date format settings. You must disable that option to get your custom date formatting to come through.