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.
Snippet used in blog post https://douglascayers.com/2019/06/22/how-to-send-google-and-outlook-calendar-invite-links-in-email-templates/