I know there’s a lot of discussion and work-around solutions about extracting the end dates and times from date fields, but I’ve searched for an cannot find the opposite task - populating a date field with a start date/time and an end date/time from other fields.
I sell hourly packages (ie 3 hour sessions, 6 hour sessions, etc) that clients can book. I have each session as a separate item in an items table. Let’s say a client purchases a 6 hour session that begins on 12/29/2022 at 9am. I enter the start date/time and select the 6 hour session. I can get Knack to figure out the end time (12/29/2022 at 3pm) by using a date formula. But once I have my start and end date/times, I cannot figure out how to populate that onto the calendar view.
The calendar view itself only uses end times from the date/time filed with the end -time option selected, and there doesn’t appear to be a way to populate the end-time with a function or a rule.
Unless I’m missing something. Thanks in advance.