Supermetrics Support Forum

I need to change the date formatting in my results

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 YYYYJanuary 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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.