Forum Discussion

sunny18pc's avatar
sunny18pc
Regular Visitor
2 years ago
Solved

Tenure Calculatoin

Hope you are doing well.   I am having trouble with a calculation: if [Active Stage] = "Active" then Duration.Days( [today]-[Joining]) else 0)   I am trying to find the tenure of employee but it...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sunny18pc 

     

    You can use below code for today. It still remains date type. 

     

    today column=Date.From(DateTime.LocalNow())

     

    Best Regards,
    Jing

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sunny18pc 

 

You can use below code for today. It still remains date type. 

 

today column=Date.From(DateTime.LocalNow())

 

Best Regards,
Jing