Change hour in date format
Hi,
I have the following format of date : 2016-01-15T01:00:00.000Z
I would like to change the 01 hour in 00, for all the dates. Does someone knows how to do it ?
Thank you,
I have the following format of date : 2016-01-15T01:00:00.000Z
I would like to change the 01 hour in 00, for all the dates. Does someone knows how to do it ?
Thank you,
Tagged:
Answers
-
You can use the find and replace processor on a substring.
Or, you could use the inc function in a custom formula.
-