Tenure Calculatoin

[sunny18pc]

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 keeps me throwing the error below for every Active records in Active Stage.
Expression.Error: We cannot apply operator - to types Text and Date.
Details:
Operator=-
Left=18-07-2024
Right=26-07-2023

today column=DateTime.ToText(DateTime.LocalNow(), "dd-MM-yyyy"))

Any help or suggestions to over come this error would be of great help. enclosing the scrrenshot to validate the date format.

[Anonymous · Accepted solution]

Hi @sunny18pc 

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

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

Best Regards,
Jing

[dufoq3]

Hi @sunny18pc, you have to change type for [today] column to date bofore you apply the formula.