Dear Team, Just to understand. Column name da...

[Etwo_Cargo]

Dear Team, Just to understand. Column name day.

Type is Duration. Inside of column settings AppFormula is today()-[date] error message: The expression is valid but its result type ‘Duration’ is not one of the expected types: Number

I am trying answer for “how many day still in warehouse”? So means that (if day is 29.11.2018) 04.12.2018-29.11.2018 = 5

Is the formula is wrong?

[Suvrutt_Gurjar]

Hi @Etwo_Cargo, Please use the expression

HOUR(TODAY() -

[Date]) /24

Since the result (days) is in numbers, the column type needs to be number type.

The above expression

is described in the article below under topic “Complex Expressions” as 5th bullet point.

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

[Levent_KULACOGL]

@Etwo_Cargo Concur with @Suvrutt_Gurjar, you can also try with:

(TODAY() - "00:00:00) - ([DateColumn] - “00:00:00”)

[Etwo_Cargo]

@Levent_KULACOGLU when i try that one. (today()"00:00:00) - ([date] - “00:00:00”) Expression ‘(today()"00:00:00) - ([date] - “00:00:00”)’ could not be parsed due to exception: Unterminated string.@Suvrutt_Gurjar

[Etwo_Cargo]

#ERROR!

[Etwo_Cargo]

Sorry guys It must be Number type instead of duration. It will show the day.

[Levent_KULACOGL]

@Etwo_Cargo

A quote is forgotten, sorry

(TODAY() - “00:00:00”) - ([DateColumn] - “00:00:00”)

[Etwo_Cargo]

Thanks a lot Dear Levent.

[Etwo_Cargo]

@Levent_KULACOGLU Gives me hours. Can we use (TODAY() - “00:00:00”) - ([DateColumn] - “00:00:00”)/24 to have day?