/event-end-time-utc.txt
Last active Jun 23, 2019
Format Event End Time in UTC in ISO-8601 Format (no dashes)
| /* 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'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
douglascayers commentedJun 23, 2019
Snippet used in blog post https://douglascayers.com/2019/06/22/how-to-send-google-and-outlook-calendar-invite-links-in-email-templates/