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 


    Xml document

    <StartTime>10:30 AM</StartTime>
    <EndTime>11:00 AM</EndTime>
    <TimestampCreate>12/10/2018 09:14:18:883</TimestampCreate>
    <TimestampChange>12/10/2018 09:14:58</TimestampChange>

    Friday, February 15, 2019 6:13 PM