0

Combining two dates fields into single appointment field

Today I have Start and End date fields and I'd like to leverage the appointment field so I need to write a script that will combine them. However the format to do for the appointment field hasn't been very clear to me. I'm fine with setting the time to 00:00 since really the are all day events anyways. Has anyone ever done this before for some guidance?

1 reply

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    Holly M

    Try this:

    AppointmentField := appointment(datetime(date(Startdate), time(0, 0)), datetime(date(Enddate), time(23, 59)))

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 44Views
  • 2 Following