none
How do I concatenate date and time from xml? RRS feed

  • Question

  • I need help to concatenate HearingDate and StartTime in this format: YYYY-MM-DDT00:00:00-06:00.

    How do I do it either in VB.Net or in xslt?

    Expected output 

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

    Xml document

    <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>

    Friday, February 15, 2019 6:13 PM