Time Formatting? Convet to text

[shermanpat]

I am trying to format some time stamps received from an API via JSON and the convert to text node doesn't seem to be able to format the date the direction i need.

The received time format look like this "2014-03-11T23:03:35.000Z" which looks to be Round-trip date/time pattern. I see in the ventuz help how to change to that format but not go from that format to a more read able format.


Can i use the convert to text node to get this reformatted?
How do I set it to local time?
Do I need to us C# to convert?

Thanks!

[Daniel Willer]

Hi there

Unfortunately you cannot but you can use a string expression to this.
date is the string input argument.

Code: Select all

System.DateTime.Parse(date).ToLocalTime().ToString("mm:ss")

[shermanpat]

Thank you, works great.

I ended up using this to get the full date to output date format I wanted.

Code: Select all

System.DateTime.Parse(A).ToLocalTime().ToString("U")