appointment

To convert given time-related values to an appointment

This function helps you to create a from-to-appointment based on 2 timestamps. Instead of the 2nd timestamp, you can also specify a duration and Ninox will return the end timestamp automatically.

If the Start and End timestamp are on the same day, the 2nd won’t be on display. Otherwise, both dates will be displayed, and you should give it enough space to show.

Syntax

appointment(any, any)

Return

appointment

Examples

Your result format may be different depending on your settings.

appointment(start, end) / appointment(start, duration) To convert 2 given time-related values to an appointment.

It doesn't matter if you add the end or the start first, Ninox will automatically select the earliest timestamp as a start.

appointment(datetime(2021, 3, 16, 19), datetime(2021, 3, 6, 17))

Result:

• 03/06/2021 17:00 – 03/16/2021 19:00 (US)

• 06/03/2021 17:00 – 16/03/2021 19:00 (UK)

appointment(datetime(2021, 5, 22, 10), time(1, 45))

Result:

• 05/22/2021 10:00 - 11:45 (US)

• 22/05/2021 10:00 - 11:45 (UK)

See also

datetime, which converts to or returns a timestamp.