Hello friends Is it possible to get a number ...

Taran_Bhagat
Participant IV

Hello friends Is it possible to get a number as difference between two dates? Please look into my screen-shot. I want to use the value 5 which is the difference between [Start date] & [Progress date] but I am getting number as 0. Any help will be much appreciated

0 4 313
4 REPLIES 4

Do you want the duration in days?

Taran_Bhagat
Participant IV

@Aleksi_Alkio yes

Translate

ranorga
Participant V

@Taran_Bhagat This is the expression you need: HOUR([Progress date] - [Start date]) / 24 For this kind of questions I recommend you

help.appsheet.com - Date and Time Expressions Date and Time Expressions help.appsheet.com

Taran_Bhagat
Participant IV

This solves my problem.Thanks a lot

Top Labels in this Space