Date format discrepancy between Appscript field type and Looker Studio

77 views

Skip to first unread message

Pia Miranda

unread,

Jan 25, 2023, 2:02:26 AM1/25/23

to Google Apps Script Community

Hello! I'm having issues with Date/Datetime field types in Apps script to be used in Looker Studio.

The field type used in Apps Script is set to YEAR_MONTH_DAY_SECONDS and the value is formatted as YYYMMDDHHMMSS as per the Documentation. The problem is when the data is brought into Looker Studio, the charts cannot recognize it as Datetime and just returns 'null' on the rows.

How do I format the datetime fields correctly that it gets passed over to Looker Studio and it being recognized as a correct Date & Time field?

Mustafa Teke

unread,

Jan 25, 2023, 2:03:14 AM1/25/23

to google-apps-sc...@googlegroups.com

25 Oca 2023 Çar, saat 10:02 tarihinde 'Pia Miranda' via Google Apps Script Community <google-apps-sc...@googlegroups.com> şunu yazdı:

Hello! I'm having issues with Date/Datetime field types in Apps script to be used in Looker Studio.

The field type used in Apps Script is set to YEAR_MONTH_DAY_SECONDS and the value is formatted as YYYMMDDHHMMSS as per the Documentation. The problem is when the data is brought into Looker Studio, the charts cannot recognize it as Datetime and just returns 'null' on the rows.

How do I format the datetime fields correctly that it gets passed over to Looker Studio and it being recognized as a correct Date & Time field?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/73f322c6-7078-456b-9c94-1b36056386ecn%40googlegroups.com.