oscarmorrison/IFTTTDate.md

Last active January 29, 2025 23:07

Star (73) You must be signed in to star a gist
Fork (8) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/oscarmorrison/bf14dab89854238d4cca.js"></script>
Save oscarmorrison/bf14dab89854238d4cca 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

jani8787 commented Jan 29, 2025

Now this is the format of the "date, time" when IFTTT passed it to Google Sheet: 'January 29, 2025 at 01:17PM' I would like to change it to 24h format because I would like to reorder the rows descending by date, time on GSheet. Now it is not working because of the AM/PM. How can I change to 24h format? Or any other solution idea? Thanks in advance. I am a kind of beginner. :)