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:...
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/

     

     

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/