Want to calculate number of days

i am trying to calculate the number of days by using calculate subraction like Delivery date - today but its giving error ‘Operation is not valid on a date 2023-11-07 in column’. what to do now?


Here you go,

Transform file.
NumberOfDays.transform (1.7 KB)

1 Like

See also:

it will work for me but for just information can we do by the CALCULATE part also na? means selecting Subraction and the dates.

The above link has examples of using Calculate for calculating the difference between 2 dates.

Sure we can,

Transform file update.
NumberOfDays.transform (2.2 KB)

1 Like

Thank you so much !! It will work for me.