##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Time
David Shimon david206
johnynek
/ gist:6632488
Last active
December 23, 2015 11:59
Sed rules for porting to scalding 0.9.0 from earlier versions. Run this in the directory with your jobs with gnu sed (brew install gnu-sed).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| find . -type f -print0 | xargs -0 gsed -i 's/\.sum(/.sum[Double](/g' | |
| find . -type f -print0 | xargs -0 gsed -i 's/\.plus\[/.sum[/g' | |
| find . -type f -print0 | xargs -0 gsed -i 's/import com.twitter.scalding.DateOps.richDateToCalendar/import com.twitter.scalding.RichDate.toCalendar/' | |
| find . -type f -print0 | xargs -0 gsed -i 's/ RichDate("\([^"]\+\)")(\([^)]\+\))/ com.twitter.scalding.DateParser.default.parse("\1")(\2).get/g' | |
| find . -type f -print0 | xargs -0 gsed -i 's/\.then[^(Do)]/.thenDo/g' | |
| find . -type f -print0 | xargs -0 gsed -i 's/Mode\.mode/mode/g' | |
| find . -type f -print0 | xargs -0 gsed -i 's/new RichDate/RichDate/g' |
oscarmorrison
/ IFTTTDate.md
Last active
December 3, 2023 21:44
Make IFTTT Date Format play nice with Google Spreadsheets
rondy
/ Effective_Engineer.md
Last active
November 17, 2024 12:50
FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.
- By Edmond Lau
- Highly Recommended 👍
- http://www.theeffectiveengineer.com/