# Convert Date and Time tags formatting for Google Calendar etc

**URL:** <https://community.homey.app/t/convert-date-and-time-tags-formatting-for-google-calendar-etc/61835>\
**Category:** Questions & Help\
**Created:** [March 19, 2022, 7:33am UTC](https://community.homey.app/t/convert-date-and-time-tags-formatting-for-google-calendar-etc/61835 "2022-03-19T07:33:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin\_K](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/martin_k/32/47966_2.png) [@Martin\_K](https://community.homey.app/u/Martin_K)\
**Post date:** [March 19, 2022, 7:33am UTC](https://community.homey.app/t/convert-date-and-time-tags-formatting-for-google-calendar-etc/61835/1 "2022-03-19T07:33:38Z")

</div>

Hi, y’all! Homey **Bridge** ≠ Pro user speaking.

❓ **How does one transform/convert the Date and Time tags (currently: `DD-MM-YYYY` and `HH:MM`) to other formats** which are then correctly interpreted by, let’s say, Google Calendar (via IFTTT), Excel, … **?**

I would like to create a log of certain events, by transferring Date and Time tags via Webhook to IFTTT – and then further on to Google Calendar or Google Spreadsheets. But the format is not compatible.

Being able to use those properties in other places, a lot of use cases would become possible.

Would be awesome to get some help on this. Maybe I missed something?

Best  
Martin

EDIT: Maybe helpful information:

> **[r/ifttt - How to format date for Google Sheets?](https://www.reddit.com/r/ifttt/comments/595nyz/how_to_format_date_for_google_sheets/dcyickf/)**
>
> 10 votes and 8 comments so far on Reddit

> <https://gist.github.com/oscarmorrison/bf14dab89854238d4cca>

---

<div class="post-metadata">

**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\
**Post date:** [March 19, 2022, 6:25pm UTC](https://community.homey.app/t/convert-date-and-time-tags-formatting-for-google-calendar-etc/61835/2 "2022-03-19T18:25:26Z")

</div>

Maybe you can try to convert in HomeyScript?

---

<div class="post-metadata">

**Author:** ![Martin\_K](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/martin_k/32/47966_2.png) [@Martin\_K](https://community.homey.app/u/Martin_K)\
**Post date:** [March 19, 2022, 10:43pm UTC](https://community.homey.app/t/convert-date-and-time-tags-formatting-for-google-calendar-etc/61835/3 "2022-03-19T22:43:46Z")

</div>

Hi Jan, if I had Homey Pro, that would be a way, yes.

For now, I only have the new Homey Bridge. 🤷‍♂️  
(I should have mentioned that, so… I just added it in my text above.)

Do you have any idea without Homey Script?

---

<div class="post-metadata">

**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\
**Post date:** [March 20, 2022, 12:09pm UTC](https://community.homey.app/t/convert-date-and-time-tags-formatting-for-google-calendar-etc/61835/4 "2022-03-20T12:09:18Z")

</div>

I’m sorry, no.