IFTTTDate.md ##Date and Time =TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) ##Date =DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) ##Time =TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) To Use Simple just place either or both separated by ||| in the Formatted Row Input on IFTTT
![Make IFTTT Date Format play nice with Google Spreadsheets](https://cdn-ak-scissors.b.st-hatena.com/image/square/1ef26f6cb4349557952890dbe3e567f7f98dc151/height=288;version=1;width=512/https%3A%2F%2Fgithub.githubassets.com%2Fassets%2Fgist-og-image-54fd7dc0713e.png)