Skip to content

Instantly share code, notes, and snippets.

@ReessKennedy

ReessKennedy/IFTTTDate.md

Forked from oscarmorrison/IFTTTDate.md
Created May 6, 2021 17:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ReessKennedy/0713e5ae83317cd7b8b514ef9972decd to your computer and use it in GitHub Desktop.
Save ReessKennedy/0713e5ae83317cd7b8b514ef9972decd to your computer and use it in GitHub Desktop.
Download ZIP
Make IFTTT Date Format play nice with Google Spreadsheets
Raw
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 Example

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment