Skip to content

Instantly share code, notes, and snippets.

@misha-tgshv

misha-tgshv/Format-FTTT-Dates.md

Last active June 28, 2020 07:18
Show Gist options
  • Save misha-tgshv/4f2503871d363e8846d6e5671e5f7819 to your computer and use it in GitHub Desktop.
Save misha-tgshv/4f2503871d363e8846d6e5671e5f7819 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Format-FTTT-Dates.md

Format IFTTT dates for Google Sheets

Example. Sending data from iOS Reminders to Google Sheet. {{CompletedDate}} value is replaced by any other.

Formatted row

=DATEVALUE(SUBSTITUTE("{{CompletedDate}}"," at ", " ")) + TIMEVALUE(SUBSTITUTE("{{CompletedDate}}"," at ", " ")) ||| {{Title}} ||| {{Notes}}

Out

=DATEVALUE(SUBSTITUTE("June 28, 2020 at 01:26PM"," at ", " ")) + TIMEVALUE(SUBSTITUTE("June 28, 2020 at 01:26PM"," at ", " "))

Format

Output date and time can tune for your choice.

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