Forum Discussion

Shree_185's avatar
Shree_185
Helper I
4 years ago
Solved

How to split date calculated column

Hello, I need help. I have calculated column "Pending Days" which calculates mins to d:hh:mm:ss format.

 

Ex - 1 day 06:20:12, I want to split it to 1.

input                output

1 day 06:20:121
23 day 05:20:1223
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Shree_185 

     

    Try this code to add a new calculated column:

    New Column = 
Var _A = LEN([input])
return
left([input],_A-13)

     

    Output:

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!


    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

1 Reply

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi Shree_185 

     

    Try this code to add a new calculated column:

    New Column = 
Var _A = LEN([input])
return
left([input],_A-13)

     

    Output:

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!


    LinkedIn:     www.linkedin.com/in/vahid-dm/