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?
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)
Thank you so much !! It will work for me.