# Adalo Calendar Date Time Format

**URL:** <https://forum.adalo.com/t/adalo-calendar-date-time-format/45239>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [February 10, 2024, 4:34pm UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239 "2024-02-10T16:34:22Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![chelseatcarter](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@chelseatcarter](https://forum.adalo.com/u/chelseatcarter)\
**Post date:** [February 10, 2024, 4:34pm UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/1 "2024-02-10T16:34:22Z")

</div>

Hello,

I am using the Google Calendar API to retrieve a list of events from my calendar which I plan to display in Adalo’s calendar component via an external collection. The value the API returns is a combined date-time value (formatted according to RFC3339). I do see Adalo recognizing the type as Date Time. However, the events are not displaying in my calendar. Any help would be appreciated.

Best,  
Chelsea

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [February 11, 2024, 12:20pm UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/2 "2024-02-11T12:20:04Z")

</div>

Hi Chelsea,

Welcome to the community 🥳

Could you show your setup with some screenshots or from a video?

---

<div class="post-metadata">

**Author:** ![chelseatcarter](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@chelseatcarter](https://forum.adalo.com/u/chelseatcarter)\
**Post date:** [February 11, 2024, 2:57pm UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/3 "2024-02-11T14:57:03Z")

</div>

Hello Dilon,

Thank you for the welcome! Yes, please see attached screenshots. I have an external collection that is populated by an API that I created that interacts with the Google Calendar API. I was sending over the DateTime format which was in RFC3339 format, but I am now converting that value to be a double based on some of the previous forums.

 ![Screenshot 2024-02-11 at 9.54.29 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/6/b/6b4998523496b12c4dcd480aa4675ce0e781313d.png)  
 ![Screenshot 2024-02-11 at 9.54.37 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/d/bd061c0bf95fbad8def826f02ca11189cf96e7a4.png)  
 ![Screenshot 2024-02-11 at 9.54.54 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/3/4/34e83406f91f6e34d5a9da7c9b0f9dd956f87e07.png)  
 ![Screenshot 2024-02-11 at 9.55.00 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/9/8923b09f9e08eda52f88671fab649835171055a5.png)

Thanks,  
Chelsea

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [February 12, 2024, 8:29am UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/4 "2024-02-12T08:29:25Z")

</div>

Hi @chelseatcarter,

I think the issue is that you don’t have any unique IDs in the events’ array. In regards to time format everything should work as you’re sending the datetime in number of days since 1/1/1970 (which is Adalo’s format).

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![chelseatcarter](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@chelseatcarter](https://forum.adalo.com/u/chelseatcarter)\
**Post date:** [February 12, 2024, 11:28am UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/5 "2024-02-12T11:28:48Z")

</div>

Thank you so much, Victor. You are absolutely correct. Now the events are showing on my calendar.  
Just to clarify, is unix time okay, or is it a necessity to break it down to the double format like such? The reason I ask is because I want to eventually display the selected time slot and know that since it is a double, I can’t set the format to be of datetime to display to the user.

 ![Screenshot 2024-02-12 at 6.25.06 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/f/d/fd337680d48eff84176e778a9ac0a5810b2f6575.png)

---

<div class="post-metadata">

**Author:** ![chelseatcarter](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@chelseatcarter](https://forum.adalo.com/u/chelseatcarter)\
**Post date:** [February 12, 2024, 11:53am UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/6 "2024-02-12T11:53:17Z")

</div>

Actually, I just tested sending the datetime value (long) from Google Calendar’s API which is in the RFC3339 format and it shows up correctly. Thanks so much again for your prompt help!

 ![Screenshot 2024-02-12 at 6.53.06 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/f/7/f780d357eb352bf675384e56fee22b20250bd4a7.png)

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [February 12, 2024, 12:18pm UTC](https://forum.adalo.com/t/adalo-calendar-date-time-format/45239/7 "2024-02-12T12:18:21Z")

</div>

Hi @chelseatcarter,

Just realised that you have full control over API and you may try to return it in ISO 8601 format. Internally Adalo operates with number of days, but it may recognise 2024-02-12T11:23:49Z in the JSON. At least worth trying 🙂

Great to hear that you’ve managed to solve it and thanks for sharing!

Best regards, Victor.
