Forum Discussion

sgp1066's avatar
sgp1066
New Member
2 years ago
Solved

Elapsed time between hire date and today

I have a hire date column and would like to have a new custom column that has the formula:   Todays Date - Hire Date. I can get this to work. Obviously I am using the field names and the columns h...
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sgp1066 

    Based on your description, I create the following sample data, its data type is date.

     

    Then create a custom column, it returns the days between hire date and today.

    DateTime.Date(DateTime.LocalNow())-[Hire Date]

     

    Then change its type to whole number.

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    And you can refer to the following attachment.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sgp1066 

Based on your description, I create the following sample data, its data type is date.

 

Then create a custom column, it returns the days between hire date and today.

DateTime.Date(DateTime.LocalNow())-[Hire Date]

 

Then change its type to whole number.

Output

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

And you can refer to the following attachment.