Want to calculate number of days

Prathamesh · November 7, 2023, 10:45am

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?

Anonymous · November 7, 2023, 11:21am

@Prathamesh,

Here you go,

Transform file.
NumberOfDays.transform (1.7 KB)

Admin · November 7, 2023, 11:44am

See also:

Prathamesh · November 7, 2023, 11:51am

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

Admin · November 7, 2023, 11:56am

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

Anonymous · November 7, 2023, 11:58am

Sure we can,

Transform file update.
NumberOfDays.transform (2.2 KB)

Prathamesh · November 7, 2023, 12:08pm

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