Skip to content

Instantly share code, notes, and snippets.

@rantoniuk

rantoniuk/IFTTTDate.md

Forked from oscarmorrison/IFTTTDate.md
Created January 14, 2017 11:09
Show Gist options
  • Save rantoniuk/9f347649a6789d521d61b77cd24a4fa0 to your computer and use it in GitHub Desktop.
Save rantoniuk/9f347649a6789d521d61b77cd24a4fa0 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