# Google Analytics Date format displayed in bubble

**URL:** <https://forum.bubble.io/t/google-analytics-date-format-displayed-in-bubble/13118>\
**Category:** Need help\
**Created:** [May 4, 2017, 6:09am UTC](https://forum.bubble.io/t/google-analytics-date-format-displayed-in-bubble/13118 "2017-05-04T06:09:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bubbleboy](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubbleboy/32/19512_2.png) [@Bubbleboy](https://forum.bubble.io/u/Bubbleboy)\
**Post date:** [May 4, 2017, 6:09am UTC](https://forum.bubble.io/t/google-analytics-date-format-displayed-in-bubble/13118/1 "2017-05-04T06:09:32Z")

</div>

I’ve read everything on date formatting in the forum. I’m pulling google analytics data via blockspring but im having an issue displaying the gadate as a correctly formatted date in bubble

GA Date is presented as 20170502 …ive set this field to date in bubble

 ![](https://us1.discourse-cdn.com/bubble/original/2X/4/4c6c6763b61e487aeda2d4937aa062211863e902.png)

I pulled the data into google sheets via blockspring to validate

 ![](https://us1.discourse-cdn.com/bubble/original/2X/8/8385b299fd3776c8cc08a1a942f2ff0906d4c85d.png)

If i use the google analytics add-on in google sheets to connect to my sheet and then use blockspring to connect to the google spreadsheet the date format works as its shown 2017-05-02

![](https://us1.discourse-cdn.com/bubble/original/2X/3/36da2536a31f30c8646e7a1fc1976e156d8da8d9.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [July 13, 2017, 6:24am UTC](https://forum.bubble.io/t/google-analytics-date-format-displayed-in-bubble/13118/2 "2017-07-13T06:24:02Z")

</div>

This topic was automatically closed after 70 days. New replies are no longer allowed.