Skip to content

Instantly share code, notes, and snippets.

@douglascayers

douglascayers/event-end-time-utc.txt

Last active June 23, 2019 03:39
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 douglascayers/3caef35e6cf9a149f69b2cb9f9d560c8 to your computer and use it in GitHub Desktop.
Save douglascayers/3caef35e6cf9a149f69b2cb9f9d560c8 to your computer and use it in GitHub Desktop.
Download ZIP
Format Event End Time in UTC in ISO-8601 Format (no dashes)
Raw
event-end-time-utc.txt
/* 1440 minutes in a day */
TEXT( YEAR( ActivityDate + DurationInMinutes / 1440 ) ) &
LPAD( TEXT( MONTH( ActivityDate + DurationInMinutes / 1440 ) ), 2, '0' ) &
LPAD( TEXT( DAY( ActivityDate + DurationInMinutes / 1440 ) ), 2, '0' ) &
'T' &
LPAD( TEXT( HOUR( TIMEVALUE( ActivityDateTime + DurationInMinutes / 1440 ) ) ), 2, '0' ) &
LPAD( TEXT( MINUTE( TIMEVALUE( ActivityDateTime + DurationInMinutes / 1440 ) ) ), 2, '0' ) &
LPAD( TEXT( SECOND( TIMEVALUE( ActivityDateTime + DurationInMinutes / 1440 ) ) ), 2, '0' ) &
'Z';
@douglascayers
Copy link
Author

Snippet used in blog post https://douglascayers.com/2019/06/22/how-to-send-google-and-outlook-calendar-invite-links-in-email-templates/

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