Solved

subtract

Hi,

i'll give any date it has to subtract with today and give me number of days difference

ex: inputdate -today= no of days difference, 04/07/2023- today = 7 days

which functions i can use to achieve this? suggest me

Best answer by sanchitg0002

No need to use a function for this, just use minus(-) operator between the dates.

tointeger(ri!input - today())

Make sure that both the inputs are of Date type.

No need to use a function for this, just use minus(-) operator between the dates.

tointeger(ri!input - today())

Make sure that both the inputs are of Date type.

Inspiring

Or we can use `abs` to not return negative numbers.

abs(ri!date1-ri!date2)

@traffic jam 3d You can use the datedif() function in Python's datetime module.

Brainy

There are no snakes in Appian! And no British comedians!

Sign up