Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to Manipulate a String in date/time format

Hi dear People,


I stuck at the following problem:

I have this Output-Data:


 "starttime": "2019-08-02T09:32:15.8335694Z",
"endtime": "2019-08-02T09:32:23.764065Z"

and it should be in this form in the end:


"starttime2": "2019-08-02 09:32:15",
"endtime2": "2019-08-02 09:32:23"

How can I achieve this?

Super User
Super User

Hi @Julian1, 2 ways: either use a Convert time zone action or add a Compose control and add a formatDateTime expression. Both of these are shown in the image below.

Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.


Community Support
Community Support

Hi @Julian1 ,


Please consider using the formatDateTime function to convert the date time format.


The function could be configured likes below:

formatDateTime('2019-08-02T09:32:15.8335694Z','yyyy-MM-dd hh:mm:ss')


More details about formatDateTime function, please check the following doc:


Best regards,



Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (58,653)