Convert Date and Time tags formatting for Google Calendar etc

Martin_K · March 19, 2022, 7:33am

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:

gist.github.com

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

IFTTTDate.md

##Date and Time
```
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
```

##Date
```
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
```
##Time

This file has been truncated. show original

JPe4619 · March 19, 2022, 6:25pm

Maybe you can try to convert in HomeyScript?

Martin_K · March 19, 2022, 10:43pm

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?

JPe4619 · March 20, 2022, 12:09pm

I’m sorry, no.

Topic		Replies	Views
Update tag date to full month name Flows	4	542	December 4, 2021
{{Now()}} in flows? Questions & Help flow	12	1186	November 6, 2022
How to use a tag for a date/time flow? Questions & Help	2	165	February 27, 2024
Thank you! Off-Topic	2	636	September 30, 2020
Convert UNIX timestamp to hh:mm Questions & Help	7	622	December 19, 2022

Convert Date and Time tags formatting for Google Calendar etc

Related Topics