How do I concatenate date and time from xml document?

Questions about XML that are not covered by the other forums should go here.
winkimjr2
Posts: 58
Joined: Thu Jun 26, 2014 9:00 pm

How do I concatenate date and time from xml document?

Post by winkimjr2 » Fri Feb 15, 2019 9:04 pm

I need help to concatenate HearingDate and StartTime in this format: YYYY-MM-DDT00:00:00-06:00. How do I do it in xslt?

Xml document

Code: Select all

<Hearing>
<Setting>
<HearingDate>07/07/2105</HearingDate>
<CourtSessionBlock>
<StartTime>10:30 AM</StartTime>
<EndTime>11:00 AM</EndTime>
</CourtSessionBlock>
<TimestampCreate>12/10/2018 09:14:18:883</TimestampCreate>
<TimestampChange>12/10/2018 09:14:58</TimestampChange>
</Setting>
</Hearing>

Output

Code: Select all

<HearingDatetimeStart>2015/01/31T10:30:00-06:00</HearingDatetimeStart>