For me, sometimes the complex date/time field has the end date just as a time (ie not as “dd/mm/yyyy hh:mm to dd/mm/yyyy hh:mm” ), so I cant constantly extract the end date/time (see table below).
That in itself is not the issue, because in this case don’t care about the end date/time, (I have already calculated what that should be and just want to write it back)
That is an ingenious way of fixing the missing end-date/time field in some of the complex date/times.
I will definitely use that! In fact I have for another part of this project.
Any chance you have a solution to second part of my question?
I don’t think I saw where you have updated a complex date/time with start and end dates with new end date/time. Even with a correctly formatted text field, I cannot seem to write that back into a complex date/time field, it just blanks out the field.
Is this correct format? “dd/mm/yyyy hh:mm to dd/mm/yyyy hh:mm” (assuming the resulting complex date/time is formatted dd/mm/yyyy hh:mm ?
Should we be able to set this, or is there another way?
Yes I understand the ability to hide the time parts and the start date part, and also I see where you set an end time field equal to the start if the actual complex date/time does not have an end time - brilliant. I also see how you are editing just the end date using a field.
However I actually need to use a formula to update the end time in the complex date/time field. I can achieve that with a simple date/time field, but it does not seem to work with a complex date/time field, and that is what I need.
What I have done is have a field that has the duration in hours, and that uses a formula to set a date/time field correctly with the end date (just adding the hours to the start date to get the end date), but then I cannot update my complex date/time field for the event so it can go into a calendar.