0

endof

To return the end timestamp of a given appointment

The function returns the end timestamp of a given appointment. The result is a value with date and time, which can be further processed or formatted.

Syntax

endof(appointement)

Return

timestamp

Examples

❗ Your result format may be different depending on your settings.

endof('Appointment') 

Result:

  • 07/03/2021 06:00 PM (US)

  • 03/06/2021 18:00 (UK)

(with Appointment =

  • 06/02/2021 09:00 AM - 07/03/2021 06:00 PM (US)

  • 02/06/2021 09:00 - 03/07/2021 18:00 (UK))

format(endof('holiday1'), "dddd, HH:mm") + " h" 

Result: Friday, 18:00 h

(with holiday1 =

  • 05/24/2021 09:00 AM - 05/28/2021 06:00 PM (US)

  • 24/05/2021 09:00 - 28/05/2021 18:00 (UK))

See also

start, which returns the start timestamp of an appointment.

Reply

null