Create Complex date (with start and end) from a simple date + end time

Ask the Community Get Answers
1

I need to combine two simple date fields (start date & time and end date & time) into a single (complex) date/time field with a start and end times for a calendar.

From KB FAQ:
## Combine a start and end date into a single field.
At present, there is no native method available to combine two date/time fields into a single field. However, with custom code and our API, you could accomplish this.

Has been asked before but was not specifically answered, does anyone have a workaround yet?

I note that the text field approach still does not work (ie create a correctly formed string in the way a complex calendar date and start end time is show) and the assigning that to a complex date.

Any (new) ideas on how people are handing this?

2

I think I did this a while ago and used Make, you could probably use Flows nowdays? You just need to get the record and then you should be able to map the two seperate dates into the one field :thinking:

1 Like
3

Doh! Great idea. I am using Make extensively in another app (never thought of that), and Flows in this one. I will try with Flows now, and report back. Cheers Carl. Calvin.

1 Like