Skip to main content

I have strings that contain date/time and I'd like to convert them. I presume I'd need to use a calculated field. Does anyone have a calculation I could use?

 

The data looks like this:

 

2018-04-23T14:58:05+00:00

2018-04-23T15:01:42+00:00

 

Many thanks,

 

Duncan

4 Antworten
  1. 23. Apr. 2018, 16:17

    Hi Duncan,

     

    Some of connection does not allow to use date related functions, but if it allows, below should work.

     

    Hi Duncan, Some of connection does not allow to use date related functions, but if it allows, below should work. You can change the format as you like.

     

    pastedImage_1.png

     

    You can change the format as you like.

    pastedImage_2.png

     

    Thanks,'

    Shin

0/9000