Change Date Range to Separate Start & End Dates

[Jaret]

I have a dropdown menu in Google Forms for people to select a date range for a partnership. (Example May 1 to 3, 2025). I need to separate that into two dates - the first and last dates.

I’m using a text parser to isolate the relevant parts of the text.

I’m following that with a Set Multiple Variables module to try and combine the parts to create a date.

I have tried Concat(), I’ve tried Join(), and other methods, but I’m stuck.

This is the error message I’m receiving.

I’m new to Make, and so far this is the only issue I haven’t been able to figure out.

I’d appreciate any help.

Thanks!
Jaret

[Shornalatha]

Hi @Jaret

We could format it like this:

This is the obtained output:

[Jaret]

Thank you so much for your response! I’ve spent hours trying different methods to get this. Thank you!!