I am trying to create Start Date/Time and End Date/Time fields. Here are my parameters:
STime (drop down)
ETime (drop down)
Start Date/Time (calculated)
=concat(substring-before(Start Date, "T"), "T", substring-after(STime, "T"))
End Date/Time (calculated)
=concat(substring-before(End Date, "T"), "T", substring-after(ETime, "T"))
All the above are set into Date and Time data type and I can't seem to make it work. The reason why I had to create a separate field for the time is because I want to make it convenient for the user to put the time by just choosing from a drop down box instead of making them manually type the time.