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