XML and formatting a date being brought in through the query report viewer
I have a MS Word template that I am loading the XML Data and one of the fields is a datetime stamp. I am displaying the field in the .RTF document with the following representation:
<?A.DATETIME_STAMP?>
When one runs the query report viewer, the output returned looks like this:
2013-09-27T14:25:23-0500
What I would like to do it get it to look this below:
2013-09-27 14:25:23
which would be just the date and time. Is there some sort of formatting I can add to the <? A.DATETIME_STAMP?> that only allows the date and time to come through like my example I posted above.
<?A.DATETIME_STAMP?>
When one runs the query report viewer, the output returned looks like this:
2013-09-27T14:25:23-0500
What I would like to do it get it to look this below:
2013-09-27 14:25:23
which would be just the date and time. Is there some sort of formatting I can add to the <? A.DATETIME_STAMP?> that only allows the date and time to come through like my example I posted above.
0